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:
(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:
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.