transpose a file: invert rows in columns

[Anonymous]

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

[Anonymous · Accepted solution]

Here is how I handle the issue :

I use tJavaFlex to split each rowThat the data generated

[Anonymous]

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