Mapping with compare result from independent nodes

[dirkmei]

Hello,

We have an interface from SAP ERP providing two table structures.

So this is

Table1:

Line 1 fields: VBELN / KUNNR => 1001 / 3579

Line 2 fields: VBELN / KUNNR = 1002 / 4680

etc...

Table 2:

Line 1 fields: VBELN / POSNR / etc... => 1001 / 010

Line 2 fields: VEBLN / POSNR / etc... => 1002 / 010

Line 3 fields: / VBELN / POSNR / ... => 1002 / 020

Line 4 fields: / VBELN / POSNR / .... => 1003 / 010

etc...

For each VBELN in table 1 we can habe n lines in Table 2 with same VBELN.

The target structure is based on Table 2 and we need to add the correct KUNNR to each target line.

Seems this is not possible with graphical mapping. Any idea how to solve this ? E.g. with a small UDF? But how?

Best regards

Dirk

[manoj_khavatkopp]

Can you please provide a sample input xml and expected output xml or the same?

[markangelo_dihiansan]

Hi Dirk,

I would suggest that you use a hashmap. For example, create a local variable mapping and save the values of table 1 in a hashmap. Then for table 2, use a simple UDF to call the hashmap for the values.

Regards,

Mark

[former_member470153]

All the values will come in sorting orders?

[apu_das2]

Did you check if Use One As Many is fulfilling your requirement or not.