+ Reply to Thread
Results 1 to 2 of 2

How to best display mapped XML with nested repeating elements

  1. #1
    Registered User
    Join Date
    08-20-2010
    Location
    Jackson, MS
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to best display mapped XML with nested repeating elements

    I have a complex XML schema that contains repeating elements nested inside of other elements. For example, A can repeat. A contains an id and a Name, as well an element B that can repeat. The space between each item of type A will, of course, be X columns long, where X is the total number of rows that all of the B elements take up for that particular A item. At the moment, all of the information contained in A repeats for each of these rows and looks confusing.

    My question is: Is there a way to not repeat information, such as Name, but instead have just blank cells?

    Visual example:

    How it looks now:
    A_id Name B_id B_name
    1 test1 b1 bone
    1 test1 b2 btwo
    1 test1 b3 bthree
    2 test2 b4 bfour
    2 test2 b5 bfive

    Much better:
    A_id Name B_id B_name
    1 test1 b1 bone
    b2 btwo
    b3 bthree
    2 test2 b4 bfour
    b5 bfive

    Edit: The spacing is messed up, but as you can see the A_id and Name does not repeat for every single row.
    Last edited by theblang; 08-20-2010 at 03:03 PM.

  2. #2
    Registered User
    Join Date
    08-20-2010
    Location
    Jackson, MS
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to best display mapped XML with nested repeating elements

    Every example I find has only one layer of nesting. Everything I try has some unintended effect. The duplication of the data makes for a really confusing spreadsheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1