I have an excel sheet with format
column a column B
aa 1
aa 2
aa 3
bb 4
bb 5
cc 6
dd 7
dd 8
I am trying to generate an xml output like
a 1 2 3 b 4 5How can i do this… I tried xmlwriter,structureddatawriter but not sure how to create this tree structure. I have a single execl sheet as input.
Hi Micky,
in order to do so you should split the stream into two. One edge for parent records (deduplicated parent fields) and the second for child elements. In XMLWriter, you can use Key and Parent Key elements on bindings. For more information please refer to our documentation - especially to Example 41.17.
I have also prepared simple example for your case (see attached project).
Hope this helps.