topic Pivoting and save data into another table in Talend Studio

Pivoting and save data into another table

Anonymous — Sat, 16 Nov 2024 07:33:32 GMT

In my job I need to save the result of my pivoting into another table:

The problem is that I don't know how to save the result in my WK1_SF_SRV_TASK table. The output in the .csv file is correct, but how can I instead use the result to fill the table? I don't know how to connect them to do this.

This table has exactly the columns that I have as a result in the excel file.

Re: Pivoting and save data into another table

Anonymous — Fri, 28 Sep 2018 11:31:20 GMT

If you are using pivot component , then you cannot get the output directly in a table. you have to put another subjob to push that output file data to a table.

Thanks ,

Praveen M.

Re: Pivoting and save data into another table

Anonymous — Fri, 28 Sep 2018 11:35:11 GMT

So each time I have to write and then read the data from the output file to fill my table?
I have to work with a lot of data, so I think I can't go this way... is there an alternative to the pivot component for pivoting the rows without passing through an output file?