Graphical Mapping Issue - using Node Functions

[Former Member]

Hi All,

I need to map the below input format to a specified sequence.

Source File

Source format	Target Needed format
Header1 Header2 Header3 (1....n) LineItem1 LineItem2 LineItem3 LineItem4 (1...n) HeaderCount,1 ItemCount,1	Header1 LineItem1 LineItem2 ...n Header2 LineItem1 LineItem2 ...n HeaderCount,1 ItemCount,1
All Headers coming together in first few rows	Need Headers to get divided as per different LineItems

Now,there is one common field in both Header and LineItem structure,which has to be used to group all Lineitems belonging to a particular Header into one at target side.

eg: Header has values - H,12,34,FIRST,SO_NUMBER

      LineItem has values - L,abc,34,SO_NUMBER,890

Can anybody help me with graphical mapping to be used using node functions for the same.

Thanks

Neha

[ambrish_mishra · Accepted solution]

Hi Neha,

This is a basic case of creating hierarchy through data type design.

This is how you can do it:

Hope the message mapping explains the source and target data type definition:

Mapping for Record node:

Mapping for LineItem node:

    

Header node is mapped to constant value null so would be created once per Record. rest of the fields are one to one.

here is the test case:

Hope it helps!

Ambrish

Message was edited by: Ambrish Mishra

[Former Member]

Thanks... It got solved...