FlatToHierarchyLoop Example

[CJIGA]

Hi:

I am trying to use the FlatToHierarchyLoop, but I can't solve my problem. I have the following information:

ID|COUNTRY|STATE_ID|STATE

1|USA|1|TN

1|USA|2|NY

1|USA|3|KY

2|PERU|4|LIM

2|PERU|5|CUZ

I expect the following result:

<root>
        <ID>USA</ID>
       <states>
             <state>

                    <state_id>1</state_id>

                    <state>TN</state>

             </state>

             <state>

                    <state_id>2</state_id>

                    <state>NY</state>

             </state>

       </states>

</root>

Please your help to give me the solution with FlatToHierarchyLoop function in Data Mapper.

[Haitao]

@CJIGA
It seems to be a different issue, could you create a new topic with Label "Talend Data Mapper" for it, please?