topic transform excel table in QlikView https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150933#M28868 <HTML><HEAD></HEAD><BODY><P>cannot edit my message above - postings have crossed: suggestion from Sidhar is the better one</P><P>Peter</P></BODY></HTML> Mon, 03 Aug 2009 16:58:56 GMT prieper 2009-08-03T16:58:56Z transform excel table https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150929#M28864 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i would like to import a excel sheet which has this structure:</P><P></P><TABLE border="1" cellspacing="0"><TBODY><TR><TH>itemnumber</TH><TH>accountnumber</TH><TH>t01</TH><TH>t02</TH><TH>t03</TH><TH>t04</TH><TH>t05</TH><TH>t06</TH><TH>t07</TH><TH>t08</TH><TH>t09</TH><TH>t10</TH><TH>t11</TH><TH>t12</TH><TH>q01</TH><TH>q02</TH><TH>q03</TH><TH>q04</TH><TH>q05</TH><TH>q06</TH><TH>q07</TH><TH>q08</TH><TH>q09</TH><TH>q10</TH><TH>q11</TH><TH>q12</TH></TR><TR><TD>16010</TD><TD>10127</TD><TD>1</TD><TD>0</TD><TD>1.6</TD><TD>2.2</TD><TD>3.1</TD><TD>1.4</TD><TD>1.6</TD><TD>0.9</TD><TD>5.2</TD><TD>2.3</TD><TD>9.7</TD><TD>7.2</TD><TD>0.7</TD><TD>0.0</TD><TD>1.1</TD><TD>2.0</TD><TD>2.5</TD><TD>1.2</TD><TD>1.1</TD><TD>0.7</TD><TD>4.4</TD><TD>2.0</TD><TD>6.8</TD><TD>5.3</TD></TR></TBODY></TABLE><P></P><P>but i want to import it with this structure:</P><P></P><TABLE border="1" cellspacing="0"><TBODY><TR><TH>itemnumber</TH><TH>accountnumber</TH><TH>month</TH><TH>turnover</TH><TH>qty (in tons)</TH></TR><TR><TD>16010</TD><TD>10127</TD><TD>jan or 01</TD><TD>1.0</TD><TD>0.7</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>feb or 02</TD><TD>0.0</TD><TD>0.0</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>mar or 03</TD><TD>1.6</TD><TD>1.1</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>apr or 04</TD><TD>2.2</TD><TD>2.0</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>may or 05</TD><TD>3.1</TD><TD>2.5</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>jun or 06</TD><TD>1.4</TD><TD>1.2</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>jul or 07</TD><TD>1.6</TD><TD>1.1</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>aug or 08</TD><TD>0.9</TD><TD>0.7</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>sep or 09</TD><TD>5.2</TD><TD>4.4</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>oct or 10</TD><TD>2.3</TD><TD>2.0</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>nov or 11</TD><TD>9.7</TD><TD>6.8</TD></TR><TR><TD>16010</TD><TD>10127</TD><TD>dez or 12</TD><TD>7.2</TD><TD>5.3</TD></TR></TBODY></TABLE><P>is there a way to realize this in the script or with the table wizard? or do i have to realize this in excel with VBA?</P></BODY></HTML> Mon, 03 Aug 2009 16:33:51 GMT https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150929#M28864 l_wassler 2009-08-03T16:33:51Z transform excel table https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150930#M28865 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Take a look at the below post. It has same requirement as yours.</P><P>http://community.qlik.com/forums/p/17151/67145.aspx#67145</P><P style="font-weight: bold">- Sridhar</P></BODY></HTML> Mon, 03 Aug 2009 16:47:15 GMT https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150930#M28865 2009-08-03T16:47:15Z AW:Re: transform excel table https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150931#M28866 <HTML><HEAD></HEAD><BODY><P>aah ok,</P><P>thank you for your quick reply <IMG alt="Big Smile" src="http://community.qlik.com/emoticons/emotion-2.gif" /></P></BODY></HTML> Mon, 03 Aug 2009 16:55:28 GMT https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150931#M28866 l_wassler 2009-08-03T16:55:28Z transform excel table https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150932#M28867 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>would suggest to</P><OL><LI>look at turnover and quantity separately</LI><LI>normalize the table using CROSS-TABLE</LI><LI>JOIN the tables separately</LI></OL><P>HTH</P><P>Peter</P></BODY></HTML> Mon, 03 Aug 2009 16:56:38 GMT https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150932#M28867 prieper 2009-08-03T16:56:38Z transform excel table https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150933#M28868 <HTML><HEAD></HEAD><BODY><P>cannot edit my message above - postings have crossed: suggestion from Sidhar is the better one</P><P>Peter</P></BODY></HTML> Mon, 03 Aug 2009 16:58:56 GMT https://community.qlik.com/t5/QlikView/transform-excel-table/m-p/150933#M28868 prieper 2009-08-03T16:58:56Z