Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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
@Harshal Parikh , To add you need to download tUnpivotRow component from Talend exchange.
https://help.talend.com/reader/9bBURCEt_t~lUHE3DeE2LA/fZEP0yvJAhbVRVQji8gFyw
@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.