topic Re: Convert columns into rows in Talend Studio

Convert columns into rows

Parikhharshal — Sat, 16 Nov 2024 01:44:56 GMT

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

Re: Convert columns into rows

Anonymous — Tue, 04 Aug 2020 03:16:03 GMT

@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

Re: Convert columns into rows

manodwhb — Tue, 04 Aug 2020 04:02:54 GMT

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

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F737&pi=marketplace%252F1%252Fproducts%252F737%252Fitems%252F1043

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

Re: Convert columns into rows

Parikhharshal — Tue, 11 Aug 2020 00:06:43 GMT

@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.