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

[Former Member]

In the first Picture, you can see the source structure. Here, the Suggestion_option is on the same Level as order_suggestion. In the second Picture below, you can see the target structure, where the order_suggestion_option must be placed under the corresponding order_suggestion. My Problem is to find a solution where i can map the entries from order_suggestion_option with corresponding field suggested_line to the correct order_suggestion (where suggested_line must match). In the end, alle Suggestion_options with the same line number in "suggested_line" should reside directly under the corresponding order_suggestion as you can see in the second Picture!