topic unpivot while reloading in QlikView https://community.qlik.com/t5/QlikView/unpivot-while-reloading/m-p/176503#M44483 <HTML><HEAD></HEAD><BODY><P>hi</P><P>ofcourse you can load data like this</P><P>Table1:</P><P>load filenumber, phone1 from ........;</P><P>Table2:</P><P>load filenumber, phone2 from ........;</P><P>Table3:</P><P>load filenumber, phone3 from ........;</P><P>this would result in 3 tables</P><P></P><P>regards</P><P>Peter</P></BODY></HTML> Mon, 07 Dec 2009 11:08:08 GMT 2009-12-07T11:08:08Z unpivot while reloading https://community.qlik.com/t5/QlikView/unpivot-while-reloading/m-p/176502#M44482 <HTML><HEAD></HEAD><BODY><P>is this possible.. this datasource has this data structure:</P><P>LOAD FileNumber,Phone1,Phone2,Phone3</P><P>FROM...</P><P>but i need the data loaded like this:</P><P>Filenumber, Phone1</P><P>Filenumber, Phone2</P><P>Filenumber, Phone 3</P><P>etc.. etc</P><P></P><P>Thanks in advanced</P></BODY></HTML> Sun, 06 Dec 2009 16:40:23 GMT https://community.qlik.com/t5/QlikView/unpivot-while-reloading/m-p/176502#M44482 amien 2009-12-06T16:40:23Z unpivot while reloading https://community.qlik.com/t5/QlikView/unpivot-while-reloading/m-p/176503#M44483 <HTML><HEAD></HEAD><BODY><P>hi</P><P>ofcourse you can load data like this</P><P>Table1:</P><P>load filenumber, phone1 from ........;</P><P>Table2:</P><P>load filenumber, phone2 from ........;</P><P>Table3:</P><P>load filenumber, phone3 from ........;</P><P>this would result in 3 tables</P><P></P><P>regards</P><P>Peter</P></BODY></HTML> Mon, 07 Dec 2009 11:08:08 GMT https://community.qlik.com/t5/QlikView/unpivot-while-reloading/m-p/176503#M44483 2009-12-07T11:08:08Z