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
