Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I am trying to convert columns to Rows and rows to columns from an input excel file to an output table.below is my scenario,
output expected is given below
Please help me to design a Talend job to get this output from the given source file
I used tPivotRow component from Talend Exchange
My example of data
Job
Effect
Don't forget to give kudos when a reply is helpful and when your query is answered, please mark the topic as resolved.
@DataTeamThanks for the quick response. I downloaded the tUnpivotRow component but unable to find it in talend open studio. i uploaded the downloaded file in Preferences>Talend>component. but it is not showing up in studio palette.
I am not using the subscription version. Is that the issue with tUnpivotRow.?