topic Re: Need Help in Transformation in qlik view in QlikView https://community.qlik.com/t5/QlikView/Need-Help-in-Transformation-in-qlik-view/m-p/593261#M1097456 <HTML><HEAD></HEAD><BODY><P>Can you provide one sample file?</P></BODY></HTML> Fri, 18 Apr 2014 06:09:15 GMT MK_QSL 2014-04-18T06:09:15Z Need Help in Transformation in qlik view https://community.qlik.com/t5/QlikView/Need-Help-in-Transformation-in-qlik-view/m-p/593260#M1097455 <HTML><HEAD></HEAD><BODY><P>i have more than 500 html files after opening in qvd. there is no order in it. </P><P>for example </P><P>course name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | course name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |academic year |academic year|</P><P>pdbvii&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |pdbvii&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2011-2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |2011-2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</P><P>name of the faculty&nbsp;&nbsp; |&nbsp;&nbsp; subject&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; semester&nbsp;&nbsp;&nbsp; | option 1&nbsp;&nbsp;&nbsp;&nbsp; | option 2&nbsp;&nbsp;&nbsp; |&nbsp; option 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | average&nbsp;&nbsp; </P><P>John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; science&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 22/12/2013&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; iv&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 2.66&nbsp;&nbsp;&nbsp;&nbsp; </P><P>.</P><P>.</P><P>.</P><P>.</P><P>.</P><P>.</P><P>.</P><P>so on</P><P>now i want to add course name and academic year in coloumns&nbsp; next to name of faculty for all&nbsp; 500 Html FILES</P><P>Course name and academic isis repeated twice ...they have used merge there</P></BODY></HTML> Fri, 18 Apr 2014 05:57:05 GMT https://community.qlik.com/t5/QlikView/Need-Help-in-Transformation-in-qlik-view/m-p/593260#M1097455 2014-04-18T05:57:05Z Re: Need Help in Transformation in qlik view https://community.qlik.com/t5/QlikView/Need-Help-in-Transformation-in-qlik-view/m-p/593261#M1097456 <HTML><HEAD></HEAD><BODY><P>Can you provide one sample file?</P></BODY></HTML> Fri, 18 Apr 2014 06:09:15 GMT https://community.qlik.com/t5/QlikView/Need-Help-in-Transformation-in-qlik-view/m-p/593261#M1097456 MK_QSL 2014-04-18T06:09:15Z