topic Re: Transposing columns into rows in Talend Studio

Transposing columns into rows

Anonymous — Wed, 15 Feb 2017 08:03:52 GMT

Before

col1    col 2 col 3
12    9 7

need this as output(after)
col1    12
col 2    9
col 3    7

Please help me out its urgent.

Re: Transposing columns into rows

Anonymous — Wed, 15 Feb 2017 09:23:24 GMT

Hi Sunny,
tsplitrow can be used for this purpose.Please follow below steps

Thanks,
Nuvvula

Re: Transposing columns into rows

Anonymous — Thu, 16 Feb 2017 07:36:56 GMT

Hey thanks for your response but as per your solution there is redundancy ,the output i needed is somewhat different
example:
This is my schema as of now
Header_Name          Header_Salary
Samy 99990
Bruno                    76435

output needed

Header_Name | Samy     |      Bruno
Header_Salary        |     99990     |      76435
So what component should i use to get this kind of output?

Re: Transposing columns into rows

Anonymous — Thu, 16 Feb 2017 19:07:13 GMT

is there any solution?

Re: Transposing columns into rows

Anonymous — Fri, 17 Feb 2017 04:09:25 GMT

Hi [font=Verdana, Helvetica, Arial, sans-serif] sunny.sehgal04[/font]

[font=Verdana, Helvetica, Arial, sans-serif] Take a look at this KB article converting rows to columns, let me know if you still have any problems.[/font]

[font=Verdana, Helvetica, Arial, sans-serif] Regards[/font]
Shong

Re: Transposing columns into rows

Anonymous — Fri, 17 Feb 2017 05:18:30 GMT

Hey Shong thanks a lot for responding but my case is quite different form the article on that link , according to my case the input columns are :
example :
Year    2011    2012 2013 2014
Unemp            22.4       22         11      11.5

So the output i needed is in this format :
Year    Unemp
2011    22.4
2012    22
2013    11
2014    11.5
i'm trying hard to find the solution of the problem but didn't found any Please can you help me in solving this.

Re: Transposing columns into rows

Anonymous — Fri, 17 Feb 2017 08:37:42 GMT

Hi
You gave us different example in your each post, they are completely different cases. Can you please show us your real case? so we can give you an accurate answer.

Regards
Shong

Re: Transposing columns into rows

Anonymous — Fri, 17 Feb 2017 10:05:54 GMT

Well the data in my file is large enough so, I'm not going to post that here , i posted an example i.e small part of my file previous example was actally data from my file i hope to get a reply from you soon .

Re: Transposing columns into rows

Anonymous — Sat, 18 Feb 2017 07:29:17 GMT

heyy Shong is there any solution?