topic Split the row value to multiple rows in Talend Studio

Split the row value to multiple rows

dipanjan93 — Sat, 16 Nov 2024 02:57:55 GMT

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.

Re: Split the row value to multiple rows

manodwhb — Tue, 17 Mar 2020 10:35:57 GMT

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

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

Re: Split the row value to multiple rows

dipanjan93 — Tue, 17 Mar 2020 10:39:02 GMT

@manodwhb - I tried this option.

But could you please explain using screenshots?

Re: Split the row value to multiple rows

manodwhb — Tue, 17 Mar 2020 10:43:58 GMT

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

Re: Split the row value to multiple rows

dipanjan93 — Tue, 17 Mar 2020 12:32:15 GMT

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

Re: Split the row value to multiple rows

manodwhb — Tue, 17 Mar 2020 12:51:10 GMT

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