Originally posted by: uvaiseodam

Hi,

I need to do the following transformation in WTX. Please find attached.

Please help me in solving this problem.

Thanks,

Uvaise Ahmed

Originally posted by: PaulBrett

That one was relatively simple.

I use an INDEX for the first record, use the 'next number for data on all the repeating groups, the last of which is discarded, because it doesn't contain any data.

Thank you.

Paul

Follow me on Twitter

Attachment(s)

Example.zip   15 KB 1 version

Originally posted by: uvaiseodam

Thanks Paul. I have modified the input by adding more fields in to array elements. Could you please help me in generating the required result. PFA.

Thanks,

Uvaise Ahmed

Attachment(s)

Input.xml   752 B 1 version

Output.xml   400 B 1 version

Originally posted by: PaulBrett

Now you're into proper mapping wizardry.  This involves assigning data rows with numbers and doing LOOKUP() functions referencing those index numbers offset by 1.

I've used 2 temporary cards with temporary structures here, so you can see the steps in sequence.

Thank you.

Paul

Follow me on Twitter

Attachment(s)

Example2.zip   17 KB 1 version

Originally posted by: uvaiseodam

Thank you so much Paul. now I can understand how to use temporary cards/maps to achieve the desired result. You are doing a great work.:)

Uvaise Ahmed