Split the row value to multiple rows

[dipanjan93]

I have a incoming row value containing ('UK', 'IT', 'DE') in the 1st iteration and ('MX') in 2nd iteration. 

My ask here is I want the output in such a way that UK should be there in 1st row, IT in 2nd Row , DE in 3rd row for the 1st iteration and MX in the fourth row during the 2nd iteration. Is it possible to achieve this scenario using tMap component.

[manodwhb]

@dipanjan93 , you can use the tNormalize component to do this ,please check the below link.

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/7N22jTuC6ZGYyjEKRH62jw

[dipanjan93]

@manodwhb - I tried this option. 

But could you please explain using screenshots?

[manodwhb]

@dipanjan93 ,please check below one,after that you need to use tjavarow or tmap to remove ' or( or ).

[dipanjan93]

But this just the 1st part of the ask. Is is possible to iterate them as well one by one?

[manodwhb · Accepted solution]

yes. After the job flow use tflowtoiterate to iterate record by record.