Four Stars

Talend Data Integration: How to iterate by several fields?

Hi, all

  I have a Excel file with some fields, such as:
 
Supplier_id    UPI_ID    Line_id    Description
6189000        A        1        colour_x
6189000        A        2        colour_xx
6189000        B        3        colour_xxx
6189000        C        4        colour_xxxx
6189000        C        5        colour_xxxxx
6189000        C        6        colour_xxxxxx

  I need to loop for each UPI_ID and then for each Line_id to get a text output field with this format:

6189000;
A;
1;colour_x;
2;colour_xx;
B;
3;colour_xxx;
C;
4;colour_xxxx;
5;colour_xxxxx;
6;colour_xxxxxx;

(all in one line but I am writing as above just to clarify the output).

  It is really much more complex but that is the idea.

Do you know how can I achive it, please?.      


Thanks in advance:
Jose