https://community.qlik.com/t5/Talend-Studio/Transpose-rows-into-columns-and-store-the-output-in-database/m-p/2231436#M21728 Hi,<BR />I am new to talend and getting to know various components. I have been struggling with an use case of mine. <BR />Use Case: Store the data in a csv report into the equivalent table in mysql<BR />Csv file of below format<BR />metric1;value1a<BR />metric2;value2a<BR />metric3;value3a<BR />..<BR />...<BR />metric10;value10a<BR />metric1;value1b<BR />metric2;value2b<BR />...<BR />metric10;value10b<BR />MySQL DB table columns / Expected Final output <BR />metric1 metric2 metric3 .... metric 10<BR />value1a value2a value3a .... value 10a<BR />value1b value 2b value3b .... value 10b<BR />my pseudo code solution for this<BR />Read the csv into table --&gt; transpose the table--&gt; map table column to db tbl column--&gt; insert value into table.<BR />I tried tUnpivotRow to accomplish but didnt get the required output. <BR />My question to the forum is these...<BR />1. Does my pseudo code solution for the use case look right?<BR />2. Is there any other component to help me achieve the transpose?<BR />Any suggestions on this use case would be of great help.<BR />Thanks in advance.<BR />Suzee Sat, 16 Nov 2024 12:54:22 GMT Anonymous 2024-11-16T12:54:22Z https://community.qlik.com/t5/Talend-Studio/Transpose-rows-into-columns-and-store-the-output-in-database/m-p/2231436#M21728 Hi,<BR />I am new to talend and getting to know various components. I have been struggling with an use case of mine. <BR />Use Case: Store the data in a csv report into the equivalent table in mysql<BR />Csv file of below format<BR />metric1;value1a<BR />metric2;value2a<BR />metric3;value3a<BR />..<BR />...<BR />metric10;value10a<BR />metric1;value1b<BR />metric2;value2b<BR />...<BR />metric10;value10b<BR />MySQL DB table columns / Expected Final output <BR />metric1 metric2 metric3 .... metric 10<BR />value1a value2a value3a .... value 10a<BR />value1b value 2b value3b .... value 10b<BR />my pseudo code solution for this<BR />Read the csv into table --&gt; transpose the table--&gt; map table column to db tbl column--&gt; insert value into table.<BR />I tried tUnpivotRow to accomplish but didnt get the required output. <BR />My question to the forum is these...<BR />1. Does my pseudo code solution for the use case look right?<BR />2. Is there any other component to help me achieve the transpose?<BR />Any suggestions on this use case would be of great help.<BR />Thanks in advance.<BR />Suzee Sat, 16 Nov 2024 12:54:22 GMT https://community.qlik.com/t5/Talend-Studio/Transpose-rows-into-columns-and-store-the-output-in-database/m-p/2231436#M21728 Anonymous 2024-11-16T12:54:22Z