https://community.qlik.com/t5/Talend-Studio/tPivotToOutputDelimited-doubt/m-p/2283392#M57322 Hi <BR />Take a look at&nbsp; <A href="https://help.talend.com/pages/viewpage.action?pageId=37851187" target="_blank" rel="nofollow noopener noreferrer">tDenormalize&nbsp;</A>component. Read the input file two times, denormalize respectively student marks and grade column, and then do an inner join base on student name column. For example: <BR />tFileInputDelimited--main--tFilterColumn-main--tDenormalize-main--tMap--main--tLogRow <BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | <BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;lookup <BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | &nbsp;&nbsp; <BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tFileInputDelimited--main--tFilterColumn-main--tDenormalize <BR />Best regards <BR />Shong <BR />&nbsp; Mon, 11 May 2015 07:58:53 GMT Anonymous 2015-05-11T07:58:53Z https://community.qlik.com/t5/Talend-Studio/tPivotToOutputDelimited-doubt/m-p/2283391#M57321 Hi,<BR />&nbsp;I have a input file and the required pivoted output file mentioned below I am not having a pivot function in the database and cannot go with a case statement &nbsp;can this be achieved through <B>tPivotToOutputDelimited</B><BR />INPUT<BR />subject;student name;student marks;<B>grade</B><BR />Maths;Ashwin Reddy;67;A<BR />Science;Ashwin Reddy;55;B<BR />English;Ashwin Reddy;88;c<BR />Computers;Ashwin Reddy;92;D<BR />Maths;Vinay Shukla;82;E<BR />Science;Vinay Shukla;66;F<BR />English;Vinay Shukla;90;G<BR />Computers;Vinay Shukla;85;H<BR />Maths;Sangeeta Thomas;72;I<BR />Science;Sangeeta Thomas;56;J<BR />English;Sangeeta Thomas;44;K<BR />Computers;Sangeeta Thomas;54;L<BR />OUTPUT REQUIRED<BR />student_name;Maths_marks;Science_marks;English_marks;Computers_marks;Maths_grade;<B>Science_grade;English_grade;Computers_grade;</B><BR />Ashwin Reddy;67;55;88;92;A;B;C;D;<BR />Vinay Shukla;82;66;90;85;E;F;G;H;<BR />Sangeeta Thomas;72;56;44;54;I;J;K;L;<BR />Thanks ,<BR />Koustubh Avadhani Fri, 08 May 2015 05:52:57 GMT https://community.qlik.com/t5/Talend-Studio/tPivotToOutputDelimited-doubt/m-p/2283391#M57321 Anonymous 2015-05-08T05:52:57Z https://community.qlik.com/t5/Talend-Studio/tPivotToOutputDelimited-doubt/m-p/2283392#M57322 Hi <BR />Take a look at&nbsp; <A href="https://help.talend.com/pages/viewpage.action?pageId=37851187" target="_blank" rel="nofollow noopener noreferrer">tDenormalize&nbsp;</A>component. Read the input file two times, denormalize respectively student marks and grade column, and then do an inner join base on student name column. For example: <BR />tFileInputDelimited--main--tFilterColumn-main--tDenormalize-main--tMap--main--tLogRow <BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | <BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;lookup <BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | &nbsp;&nbsp; <BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tFileInputDelimited--main--tFilterColumn-main--tDenormalize <BR />Best regards <BR />Shong <BR />&nbsp; Mon, 11 May 2015 07:58:53 GMT https://community.qlik.com/t5/Talend-Studio/tPivotToOutputDelimited-doubt/m-p/2283392#M57322 Anonymous 2015-05-11T07:58:53Z