PI Graphical Mapping with loops?

[Former Member]

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

[markangelo_dihiansan · Accepted solution]

Hello Elmar,

This needs a UDF since Order_Suggestion contains two entries while Order_Suggestion_Option_Contains three entries in your example. You may use this mapping:

For Order_Suggestion:

For Suggested_Line/X_Feature_ID/Option/Sequential_No/

Now, for the Order_Suggestion_Option: There are two ways to map this

a. Use SplitByValue:ValueChanged

Cons of this is that you are not checking the input from Order_Suggestion-item-Suggested_Line

b. Via UDF

Cons, needs a user-defined function to work. UDF type is Context Type:

Arguments: inp1 type String[]

inp2 type String[]

for(int a=0;a<inp1.length;a++){
     int c=0;
     for(int b=0;b<inp2.length;b++){
          if(inp1[a].equals(inp2[c])){
               if(c+1<inp2.length){
                   if(inp1[a].equals(inp2[c+1])){ 
                        result.addValue(inp2[c]);
                    }
                    else if(!inp1[a].equals(inp2[c+1])){
                         result.addValue(inp2[c]);
                         result.addContextChange();
                    }
               }
               else{
                    result.addValue(inp2[c]);
               }
          }
     c++;
     }
}

Please forgive the unoptimized code.

Hope this helps

Mark

[Former Member · Accepted solution]

Hi!

First of all, thank you all for those numerous replies! I tried every solution and all of them work, but only for the first element ...

@Mark, i tried your solution A, but it just doesn't work ...

Result:

The other two entries are missing

[markangelo_dihiansan · Accepted solution]

Hello Elmar,

Edit: The logic provided by Amit should work. Suggested_Line followed by a removeContext and sort and splitByValue:ValueChanged should create the Order_Suggestion_Option entries.

Regards,

Mark

Message was edited by: Mark Dihiansan

[Former Member · Accepted solution]

Hello! I also tried Amit's solution, as you can see here ... but i still only get 1 entry for 100 and 200. What happens to the other entries? There should be 2 for 100 and 2 for 200 ...

Result: The order_suggestion_options for 1-2 and 2-2 are missing ... it seems that the logic only processes the first element for 100 and 200 and then quits ;(

[Former Member · Accepted solution]

I attached another screenshot, so that you can exactly see the data that i used for the test! Only the first two elements in order_suggestion_option are processed ... 1-2 and 2-2 are missing!

[Former Member · Accepted solution]

Hello,

I think you are not changing the context of the fields?

Change the context of each source field (right click on field name -> context) and set it to MT** name

Thanks

Amit Srivastava

[Former Member · Accepted solution]

Hi Amit!

Now, i tried it like this, but it seems that the order_suggestion_option elements are not sorted! It seems to be one step closer to a solution, but something must still be wrong ...

Result:

[Former Member · Accepted solution]

Hello,

As stated previously u have to change the context of each and every source field (under order_suggested_option node).

In addition to that, the output of remove context will be the input to “SortByKey”.

Thanks

Amit Srivastava

[Former Member · Accepted solution]

Hi Amit!

I tried to Change the context of alle source fields, but i have three possibilites ... Standard was "item". I changed all source fields (Suggested_line, x_Feature_id, Option and sequence_no) to ORDER_SUGGESTION_OPTION. With NO success Then i tried the root node "Z_EXP_....", also with no success. Is there still something that i am doing wrong?

[Former Member · Accepted solution]

Hi Amit!

With your additional Input and a Little Change to the mapping, it works!!

Correct result:

Thanks to all, who tried to help me!!

BR, EF