Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a CSV file which has 19 columns & 8356 rows. So total no. of records are 158,764.
I want to transpose/change all 19 columns into rows & all 8356 rows into columns along with an additional column which represents sequence starting from 1 for no. of rows.
So my output should have now 8357 columns(one additional column for sequence) & 19 rows.
Since I am new in Talend, Kindly help me with screenshots of the components and methods used.
Thanks
Hello,
Could you please give us more information about your job requirement? Elaborating your case with an example with input and expected output values will be preferred
Best regards
Sabrina
Hi,
I have a file which has a total of 19 columns. I have attached a sample of that file which has 9 columns (ORG_STATUS_ID, ORG_STATUS_CATEGORY,........, PENDING) for your reference. These columns contain many rows.
so I want to transpose all 9 columns to rows and all these rows to columns. Also, I want to number these rows from 1,2,3,.......and so on as described in output screenshot I have attached.
Input:
Expected output:
Please describe me with the components to be used along with screenshots and their mappings.
Thanks