Six Stars dgm
Six Stars

transpose a file: invert rows in columns

Here is the structure of the file :
id|country_code|Country_name
1,2,3|cm,fr,us|Cameroon,France,United States

We want to transform it to something like :
id|country_code|Country_name
1|cm|Cameroon
2|fr|France
3|us|United States

 

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

1 REPLY
Six Stars dgm
Six Stars

Re: transpose a file: invert rows in columns

Here is how I handle the issue :

job-talend.JPG

I use tJavaFlex to split each rowtjavaflex.JPGThat the data generated trowgenerator.JPG