topic Loading data with specified fields from all excel files in a folder in QlikView https://community.qlik.com/t5/QlikView/Loading-data-with-specified-fields-from-all-excel-files-in-a/m-p/306049#M113015 <HTML><HEAD></HEAD><BODY><P>Below is the scenerio i want to implement in my project. </P><P></P><P>There are 100 xls files in a folder, where some of&nbsp; files having fields - <STRONG>a,b,c , d</STRONG>&nbsp; some files having fields only - a , b . </P><P>I want to load data from all xls files in that folder into one table containing all the 4 fields - a,b,c, d and store it into a qvd.</P><P></P><P>Note : It is not possible for me to find the name of the files which have all the 4&nbsp; fields,&nbsp; as the files are being added everyday whereas only few files will ve all fields.</P><P></P><P>Can anyone help me a quick solution for this.</P><P></P><P></P><P>Thanks,</P><P>Sankar</P></BODY></HTML> Wed, 22 Feb 2012 06:35:02 GMT 2012-02-22T06:35:02Z Loading data with specified fields from all excel files in a folder https://community.qlik.com/t5/QlikView/Loading-data-with-specified-fields-from-all-excel-files-in-a/m-p/306049#M113015 <HTML><HEAD></HEAD><BODY><P>Below is the scenerio i want to implement in my project. </P><P></P><P>There are 100 xls files in a folder, where some of&nbsp; files having fields - <STRONG>a,b,c , d</STRONG>&nbsp; some files having fields only - a , b . </P><P>I want to load data from all xls files in that folder into one table containing all the 4 fields - a,b,c, d and store it into a qvd.</P><P></P><P>Note : It is not possible for me to find the name of the files which have all the 4&nbsp; fields,&nbsp; as the files are being added everyday whereas only few files will ve all fields.</P><P></P><P>Can anyone help me a quick solution for this.</P><P></P><P></P><P>Thanks,</P><P>Sankar</P></BODY></HTML> Wed, 22 Feb 2012 06:35:02 GMT https://community.qlik.com/t5/QlikView/Loading-data-with-specified-fields-from-all-excel-files-in-a/m-p/306049#M113015 2012-02-22T06:35:02Z Loading data with specified fields from all excel files in a folder https://community.qlik.com/t5/QlikView/Loading-data-with-specified-fields-from-all-excel-files-in-a/m-p/306050#M113016 <HTML><HEAD></HEAD><BODY><P>Download the QV Cookbook from</P><P><A href="http://robwunderlich.com/downloads/">http://robwunderlich.com/downloads/</A></P><P></P><P>and take a look at the example "Load multiple sheets from Excel workbook". You may be able to adapt it your needs.</P><P>See also:</P><P><A href="http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html">http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html</A></P><P></P><P>-Rob</P></BODY></HTML> Wed, 22 Feb 2012 07:13:15 GMT https://community.qlik.com/t5/QlikView/Loading-data-with-specified-fields-from-all-excel-files-in-a/m-p/306050#M113016 rwunderlich 2012-02-22T07:13:15Z