Mapping on complex to simple tree structure

[Former Member]

Hi experts

Please help on the following mapping requirement: input structure

Output:

The output invoice_detail is mapped to input3-dat-invoices-record-invoice. invoiceid is mapped to invoiceid. However, the input invoices node can have cardinality 1..3 and the record may not exist. The first available invoice value is mapped to invoice_detail. If there is no invoice node available, no mapping should happen.

For example: input

output should be:

mt_output3

data

invoiceid x1

invoice_detail inv11

data

invoiceid x2

invoide_detail inv21

data

invoiceid x3

I would like to stay with graphical mapping. If I change it to XSLT, there are too many changes. Note that this is just a small portion of the real mapping.

Your help is much appreciated.

[anupam_ghosh2 · Accepted solution]

Hi jonathanma,

please try following mapping

record node's context should also be "data".

result

----

regards

Anupam