topic How to perform incremental Excel file loads where dates are written in Excel file names in QlikView https://community.qlik.com/t5/QlikView/How-to-perform-incremental-Excel-file-loads-where-dates-are/m-p/682445#M1083909 <HTML><HEAD></HEAD><BODY><P>Hello together.&nbsp; Just started on this Qlikview adventure and I have already a question concerning incremental loads.&nbsp; I have found some answers, but none respond to the actual need I have:&nbsp; We would like to create daily Excel reports to be read into Qlickview.&nbsp; There are hundreds already and each day an extra file is lying on a file server (with slow connection speed).&nbsp; Hence I wish to read the files once as an initial load, then only the new files.&nbsp; To compare the "newness" of the file, I wish to use the date that is written within the filename.&nbsp; i.e.: </P><P><IMG alt="excels for qlikview.GIF.gif" class="jive-image" src="/legacyfs/online/61455_excels for qlikview.GIF.gif" style="width: 620px; height: 135px;" /></P><P></P><P>Currently, I have only achieved to open the file, read a date field inside the file, and then to continue.&nbsp; But this approach seems too slow -&nbsp; just as fast as re-LOADing all excel files. Any ideas how to make this incremental LOAD work, and to make it performant?&nbsp; Thank you</P></BODY></HTML> Mon, 30 Jun 2014 15:46:19 GMT 2014-06-30T15:46:19Z How to perform incremental Excel file loads where dates are written in Excel file names https://community.qlik.com/t5/QlikView/How-to-perform-incremental-Excel-file-loads-where-dates-are/m-p/682445#M1083909 <HTML><HEAD></HEAD><BODY><P>Hello together.&nbsp; Just started on this Qlikview adventure and I have already a question concerning incremental loads.&nbsp; I have found some answers, but none respond to the actual need I have:&nbsp; We would like to create daily Excel reports to be read into Qlickview.&nbsp; There are hundreds already and each day an extra file is lying on a file server (with slow connection speed).&nbsp; Hence I wish to read the files once as an initial load, then only the new files.&nbsp; To compare the "newness" of the file, I wish to use the date that is written within the filename.&nbsp; i.e.: </P><P><IMG alt="excels for qlikview.GIF.gif" class="jive-image" src="/legacyfs/online/61455_excels for qlikview.GIF.gif" style="width: 620px; height: 135px;" /></P><P></P><P>Currently, I have only achieved to open the file, read a date field inside the file, and then to continue.&nbsp; But this approach seems too slow -&nbsp; just as fast as re-LOADing all excel files. Any ideas how to make this incremental LOAD work, and to make it performant?&nbsp; Thank you</P></BODY></HTML> Mon, 30 Jun 2014 15:46:19 GMT https://community.qlik.com/t5/QlikView/How-to-perform-incremental-Excel-file-loads-where-dates-are/m-p/682445#M1083909 2014-06-30T15:46:19Z