topic transpose a file: invert rows in columns in Talend Studio

transpose a file: invert rows in columns

Anonymous — Tue, 05 Jun 2018 16:19:53 GMT

That's just a sample, the file we have is 6000 items

Anonymous — Tue, 05 Jun 2018 21:15:55 GMT

Here is how I handle the issue :

I use tJavaFlex to split each rowThat the data generated

Anonymous — Sun, 22 Jul 2018 11:54:04 GMT

you can achieve this with help of tnormalizerow and numeric sequence routine.

using tnormalizerow and sequence routine you will have to generate following

id seq country code seq country_name seq

1 1 cm 1 cameroon 1

2 2 fr 2 france 2

3 3 fr 3 united states 3

after this you can perform join operation on seq column

and you will get

id|country_code|Country_name
1|cm|Cameroon
2|fr|France
3|us|United States

This is applicable for n number of records