Question Re: Mapping on complex to simple tree structure in Technology Q&A

Mapping on complex to simple tree structure

Former Member — Tue, 27 Oct 2020 22:03:27 GMT

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.

Re: Mapping on complex to simple tree structure

Former Member — Tue, 27 Oct 2020 22:06:34 GMT

The biggest issue is that data-invoices-record may not exist. That makes most of the node functions not working when I tried to align the invoice node against the data node. The invoice node tends to shift out of context position whenever we have blank record node.

Re: Mapping on complex to simple tree structure

Former Member — Wed, 28 Oct 2020 13:17:18 GMT

Anyone can help?

Re: Mapping on complex to simple tree structure

anupam_ghosh2 — Fri, 30 Oct 2020 07:09:03 GMT

Hi jonathanma,

please try following mapping

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

result

----

regards

Anupam

Re: Mapping on complex to simple tree structure

Former Member — Fri, 30 Oct 2020 13:28:01 GMT

Thank you, Anupam. That is a very smart solution. It works great. Thank you again.

Re: Mapping on complex to simple tree structure

anupam_ghosh2 — Thu, 12 Nov 2020 03:58:51 GMT

Great to know , solution worked for you. All the best. Keep smiling.

Regards

Anupam