topic Data Transformation in Load Script in QlikView https://community.qlik.com/t5/QlikView/Data-Transformation-in-Load-Script/m-p/1290421#M846646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to load a large Excel-table into Qlikview. The table looks something like this:</P><P><IMG alt="Table1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157817_Table1.png" style="width: 620px; height: 101px;" /></P><P></P><P>I would like to create a table in Qlikview that looks like this:</P><P><IMG alt="Table2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/157818_Table2.png" style="height: auto;" /></P><P>Can this be achieved using data transformation? What would the script look like?</P><P></P><P>Thanks</P><P>Peter</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Coldie 2020-11-25T16:16:04Z Data Transformation in Load Script https://community.qlik.com/t5/QlikView/Data-Transformation-in-Load-Script/m-p/1290421#M846646 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to load a large Excel-table into Qlikview. The table looks something like this:</P><P><IMG alt="Table1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157817_Table1.png" style="width: 620px; height: 101px;" /></P><P></P><P>I would like to create a table in Qlikview that looks like this:</P><P><IMG alt="Table2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/157818_Table2.png" style="height: auto;" /></P><P>Can this be achieved using data transformation? What would the script look like?</P><P></P><P>Thanks</P><P>Peter</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Data-Transformation-in-Load-Script/m-p/1290421#M846646 Coldie 2020-11-25T16:16:04Z Re: Data Transformation in Load Script https://community.qlik.com/t5/QlikView/Data-Transformation-in-Load-Script/m-p/1290422#M846647 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See if this help you:</P><P></P><P><A href="https://community.qlik.com/thread/112003">Multiple header in the excel</A></P></BODY></HTML> Tue, 28 Mar 2017 07:18:52 GMT https://community.qlik.com/t5/QlikView/Data-Transformation-in-Load-Script/m-p/1290422#M846647 sushil353 2017-03-28T07:18:52Z