PI graphical mapping: target node based on two source nodes

[Former Member]

Hello experts,

I have an incoming structure like this:

the target structure is:

Where (number of ITEM) = (number of SPLIT) X (number of LINEITEM)

EMAIL = SPLIT[Owner]

PARTN_ROLE = Index of SPLIT

ITM_NUMBER = LINEITEM[LineNumber]

How do I do this using graphical mapping and/or UDFs?

Any help is appreciated.

Thanks!

[markangelo_dihiansan · Accepted solution]

Hi Kiryl,

Please let me know if I've interpreted your requirements correctly:

For item:

For PARTN_ROLE

For EMAIL: Context of Owner is set to Splits (one level higher), only this UDF has a parameter value

For ITM_NUMBER

Test

Regards,

Mark

[Former Member · Accepted solution]

Thank you, Mark

great job!

One little thing. PARTN_ROLE should be = Index of SPLIT, but I figured this part by myself, based on ITM_NUMBER part.

[former_member186851]

Hello Kiryl ,

Graphical mapping should do.

1.(number of ITEM) = (number of SPLIT) X (number of LINEITEM)

EMAIL = SPLIT[Owner]

Select statistic function count and arithmetic function multiply. You can use removecontexts if the splits are coming in different contexts.

ITem = Count[SPLIT} Multiply Count[LINEITEM]

2.EMAIL = SPLIT[Owner]

you can do a direct mapping here.

3.PARTN_ROLE = Index of SPLIT

Try index of function in TEXT. When you say index of split any character index in split?

4.ITM_NUMBER = LINEITEM[LineNumber]

you can do a direct mapping here.