PI Graphical Mapping with loops?

[#1]

Hi!

I have the following Problem and would like to know if there is an elegant solution to it!

I want to map the Output of a function block to an XML structure. So there is nothing so Special about it

The Problem is the following:

In the source structure there are 2 tables:

Table1:

Field 1, Field 2

xyz     001

abc     002

Table2:

Field 1, Field 2, Field 3

mno     abc    001

abc     xyz     001

xyz     ako     002

A part of the target structure of the XML Looks like this:

<Tag1>

     <Subtag 1>001</Subtag1>

          --> Here All entries from Table 2 whose Field 3 corresponds to Field 2 of Table 1 should be placed!!

               <Tag2>

                    <Subtag2>mno</Subtag2>

                    <Subtag3>abc</Subtag3>

               </Tag2>

               <Tag2>

                    <Subtag2>abc</Subtag2>

                    <Subtag3>xyz</Subtag3>

               </Tag2>

     <Subtag 1>002</Subtag1>

               <Tag2>

                    <Subtag2>xyz</Subtag2>

                    <Subtag3>ako</Subtag3>

               </Tag2>

</Tag1>

Is there a solution to this by a graphical mapping?

BR, EF

[ambrish_mishra]

Hi Elmar,

I think Tag2 should be a child of SubTag1?

You can use standard functions to achieve this.

Map  Table1 field2 (context Table1) to <SubTag1>

Map Table 2 field3 (context Table2) Split by value (Value Changed) to <Tag2>

for population of fields map fields directly from table 2.

Let me know if you are able to work it out else will quickly prototype it.

cheers,

Ambrish

PS: Based on assumption that table 1 and table 2 are sorted.