Transpose rows into columns and store the output in database

One Star

Transpose rows into columns and store the output in database

Hi,
I am new to talend and getting to know various components. I have been struggling with an use case of mine.
Use Case: Store the data in a csv report into the equivalent table in mysql
Csv file of below format
metric1;value1a
metric2;value2a
metric3;value3a
..
...
metric10;value10a
metric1;value1b
metric2;value2b
...
metric10;value10b
MySQL DB table columns / Expected Final output
metric1 metric2 metric3 .... metric 10
value1a value2a value3a .... value 10a
value1b value 2b value3b .... value 10b
my pseudo code solution for this
Read the csv into table --> transpose the table--> map table column to db tbl column--> insert value into table.
I tried tUnpivotRow to accomplish but didnt get the required output.
My question to the forum is these...
1. Does my pseudo code solution for the use case look right?
2. Is there any other component to help me achieve the transpose?
Any suggestions on this use case would be of great help.
Thanks in advance.
Suzee