on 03-19-2011 3:00 AM
Hello Pros
I have a requirement where I need to transpose a structure. My input is illustrated below. In this example the output file has one u201Cheader level recordu201D, two u201CIntermediate level recordsu201D, and four u201CItem level recordsu201D (2items per Intermediate record, hence 4 total item level records).
I assume to achieve this in a 2 step process. First I had a MM for idoc>file to populate my dataset. Now Iu2019m attempting to transpose the structure as a second MM step. Originally I attempted to do this in 1 step and thought successful but where I fell short was the u201Cintermediate levelu201D records in the 3rd and 4th positions (see output below) pulled incorrect values when transposed.
Input Nodes:
<HeaderRequest>
<HeaderRecrod1/>
<HeaderRecrod2/>
<IntermediateRequest>
<intermediate1/>
<intermediate2/>
<ItemRequest>
<item1/>
<item2/>
</ItemRequest>
</IntermediateRequest>
</HeaderRequest>
The output I require is noted below.
Output Nodes
RecordInformation
HeaderRequest u2026 (headerRequest1>IntermediateRequest1>itemRequest1.1)
HeaderRequest u2026 (headerRequest1>IntermediateRequest1>itemRequest1.2)
HeaderRequest u2026 (headerRequest1>IntermediateRequest2>itemRequest2.1)
HeaderRequest u2026 (headerRequest1>IntermediateRequest2>itemRequest2.2)
Please note, lets just say there is no data in u201CHeaderRecord1u201D (see u201Cinputu201D structure above) trying to utilize u201CuseoOeAsManyu201D will throw an error.
Hi,
Try using the Constants function CopyValue[0] with index 0
Regards,
Aravind
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.