Transposing columns into rows

One Star

Transposing columns into rows

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.

One Star

Re: Transposing columns into rows

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




Thanks,
Nuvvula
One Star

Re: Transposing columns into rows

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?
One Star

Re: Transposing columns into rows

is there any solution?
Community Manager

Re: Transposing columns into rows

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Transposing columns into rows

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.
Community Manager

Re: Transposing columns into rows

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Transposing columns into rows

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 Smiley Happy.
One Star

Re: Transposing columns into rows

heyy Shong is there any solution?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch