Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dipanjan93
Contributor
Contributor

Split the row value to multiple rows

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.

Labels (3)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

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

View solution in original post

5 Replies
manodwhb
Champion II
Champion II

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

 

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

 

dipanjan93
Contributor
Contributor
Author

@manodwhb - I tried this option. 

 

But could you please explain using screenshots?

manodwhb
Champion II
Champion II

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

 

dipanjan93
Contributor
Contributor
Author

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

manodwhb
Champion II
Champion II

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