Convert columns into rows

[Parikhharshal]

Hi Talend experts

Is this possible to transpose columns into rows with following input:

first name previous value new value last

name previous value new value middle name previous value new value address previous value new value

I want the output like this:

Field name previous value new value

first name

last name

middle name

address

[Anonymous]

@Harshal Parikh​ , Here is an article shows how to convert columns to rows, please take a look at it and let me know if it meets your need. If not, can you please give us an example with some data to explain your case? We will see if we could suggest a way or solution to do it.

https://help.talend.com/reader/q_sasaKb7xsYBw8qh5xXzQ/hYV_ezfSk416T6G2z_3OaA

Regards

Shong

[manodwhb]

@Harshal Parikh​ , To add you need to download tUnpivotRow component from Talend exchange.

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

https://help.talend.com/reader/9bBURCEt_t~lUHE3DeE2LA/fZEP0yvJAhbVRVQji8gFyw

[Parikhharshal]

@Shicong Hong​ 

I have uploaded file here.

The output I am looking for is also in the file.

Would really appreciate if you could advise what's the best solution.