Pivoting and save data into another table

[Anonymous]

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. 

[Anonymous]

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.

[Anonymous]

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?