XML Data Set with Many To One

Maybe I missed it, but could someone help with this example:
XML Data, similar to:
<report>
<highlevelitem>
<description>description</description>
...
<lowlevelitems>
<lowlevelitem index="1">
<entry>some text</entry>
...
</lowlevelitem>
...
</lowlevelitems>
</highlevelitem>
</report>

How do I build a data set(s) to get the "lowlevelitems" inside of the high level items? e.g. one to many relationship...

Find more posts tagged with

Comments

rlsbirt

Sorry, meant to say one to many...

mwilliams

Hi rlsbirt,

Can you provide some actual xml data and what you would like the dataSet to look like? Thanks.

Tianli

I suppose you want to get all "entry" and "index" of lowlevelitems in each highlevelitems. Maybe it is not what you want, but may bring you some inspiration:)

For following xml you can use "/report/highlevelitem/lowlevelitems/lowlevelitem" as Row Mapping
Column mapping is entry: "/entry"; index: "/@index" and description:"../../description"

The result is
entry| index| description
1|A|highlevelitem1
2|B|highlevelitem1
3|C|highlevelitem1
...|...|highlevelitem2

<report>
<highlevelitem>
<description>highlevelitem1</description>
<lowlevelitems>
<lowlevelitem index="1">
<entry>A</entry>
</lowlevelitem>
<lowlevelitem index="2">
<entry>B</entry>
</lowlevelitem>
<lowlevelitem index="3">
<entry>C</entry>
</lowlevelitem>
</lowlevelitems>
</highlevelitem>
<highlevelitem>
<description>highlevelitem2</description>
...
</report>