topic Re: This is practice question in QlikView https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598394#M221543 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">LOAD *,</SPAN></P><P>&nbsp; FileName() as Excelnames</P><P>FROM</P><P>*.xlsx</P><P>(ooxml, embedded labels, table is [$(*)]);</P></BODY></HTML> Mon, 03 Feb 2014 06:39:23 GMT MK_QSL 2014-02-03T06:39:23Z This is practice question https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598391#M221540 <HTML><HEAD></HEAD><BODY><P>How can i load multiple excel sheets in to qv at a tile </P></BODY></HTML> Mon, 03 Feb 2014 05:13:10 GMT https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598391#M221540 2014-02-03T05:13:10Z Re: This is practice question https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598392#M221541 <HTML><HEAD></HEAD><BODY><P>Yes Definately,</P><P></P><P>Actually you can use for loop statement to iterate all the sheets to load all sheets to qv at a time</P></BODY></HTML> Mon, 03 Feb 2014 05:21:31 GMT https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598392#M221541 Anonymous 2014-02-03T05:21:31Z Re: This is practice question https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598393#M221542 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Rao,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Check with this <A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="4452" data-objecttype="102" href="https://community.qlik.com/docs/DOC-4452" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">Load Multiple excel sheets using For loop</A></P></BODY></HTML> Mon, 03 Feb 2014 06:37:13 GMT https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598393#M221542 jvishnuram 2014-02-03T06:37:13Z Re: This is practice question https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598394#M221543 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">LOAD *,</SPAN></P><P>&nbsp; FileName() as Excelnames</P><P>FROM</P><P>*.xlsx</P><P>(ooxml, embedded labels, table is [$(*)]);</P></BODY></HTML> Mon, 03 Feb 2014 06:39:23 GMT https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598394#M221543 MK_QSL 2014-02-03T06:39:23Z Re: This is practice question https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598395#M221544 <HTML><HEAD></HEAD><BODY><P>hi</P><P>see link</P><P><A href="https://community.qlik.com/docs/DOC-4452">Load Multiple excel sheets using For loop</A></P></BODY></HTML> Mon, 03 Feb 2014 06:42:18 GMT https://community.qlik.com/t5/QlikView/This-is-practice-question/m-p/598395#M221544 2014-02-03T06:42:18Z