topic Re: Excel Upload in QlikView https://community.qlik.com/t5/QlikView/Excel-Upload/m-p/468599#M175021 <HTML><HEAD></HEAD><BODY><P>Hope, somebody can help.</P></BODY></HTML> Thu, 13 Jun 2013 17:20:20 GMT 2013-06-13T17:20:20Z Excel Upload https://community.qlik.com/t5/QlikView/Excel-Upload/m-p/468597#M175019 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I have to load data from excel with a specific format. i need help. am attaching the sample excel and expected output below:</P><P></P><P>Expected Output:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 80%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SheetName</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Dim2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Data</STRONG></SPAN></TH></TR><TR><TD>AAA</TD><TD>ABC1</TD><TD>1/1/2013</TD><TD>100</TD></TR><TR><TD>AAA</TD><TD>ABC1</TD><TD>1/2/2013</TD><TD>200</TD></TR><TR><TD>AAA</TD><TD>ABC2</TD><TD>1/1/2013</TD><TD>300</TD></TR><TR><TD>AAA</TD><TD>ABC2</TD><TD>1/2/2013</TD><TD>400</TD></TR><TR><TD>AAA</TD><TD>ABC3</TD><TD>1/3/2013</TD><TD>500</TD></TR><TR><TD>AAA</TD><TD>ABC3</TD><TD>1/4/2013</TD><TD>600</TD></TR><TR><TD>BBB</TD><TD>BCD1</TD><TD></TD><TD>1</TD></TR><TR><TD>BBB</TD><TD>BCD1</TD><TD>..</TD><TD>2</TD></TR><TR><TD>BBB</TD><TD>BCD1</TD><TD></TD><TD>3</TD></TR><TR><TD>BBB</TD><TD>BCD2</TD><TD></TD><TD>4</TD></TR><TR><TD>...</TD><TD>...</TD><TD></TD><TD></TD></TR></TBODY></TABLE><P>.</P><P>Note: The number of sheets and number of columns are not fixed. so i would require a dynamic solution.</P><P></P><P>Any help is much appreciated.</P><P></P><P></P><P>Regards,</P><P>Amit</P></BODY></HTML> Thu, 13 Jun 2013 07:51:28 GMT https://community.qlik.com/t5/QlikView/Excel-Upload/m-p/468597#M175019 2013-06-13T07:51:28Z Re: Excel Upload https://community.qlik.com/t5/QlikView/Excel-Upload/m-p/468598#M175020 <HTML><HEAD></HEAD><BODY><P>Could anybody help?</P></BODY></HTML> Thu, 13 Jun 2013 10:56:14 GMT https://community.qlik.com/t5/QlikView/Excel-Upload/m-p/468598#M175020 2013-06-13T10:56:14Z Re: Excel Upload https://community.qlik.com/t5/QlikView/Excel-Upload/m-p/468599#M175021 <HTML><HEAD></HEAD><BODY><P>Hope, somebody can help.</P></BODY></HTML> Thu, 13 Jun 2013 17:20:20 GMT https://community.qlik.com/t5/QlikView/Excel-Upload/m-p/468599#M175021 2013-06-13T17:20:20Z