https://community.qlik.com/t5/QlikView/Load-data-that-is-not-yet-read/m-p/1508645#M750459 <P>You can load all the csv files once into one table and then store that table into a qvd file. The next time you need only load the latest csv file and all the data from the qvd file and then store the complete table again in the qvd file. It's called incremental loading. The trick then is to know which csv file is the latest. Perhaps your csv files have a date in their file name and you can use that. Or you could check the creation times of the files. Here are some discussions on that topic:</P><UL><LI><A href="https://community.qlik.com/t5/QlikView-App-Development/Load-the-latest-file-of-a-folder/td-p/192461" target="_blank">https://community.qlik.com/t5/QlikView-App-Development/Load-the-latest-file-of-a-folder/td-p/192461</A></LI><LI><A href="https://community.qlik.com/t5/QlikView-App-Development/To-Know-Last-Refreshed-Date-of-Excel-CSV-and-Qvd-s/td-p/1057874" target="_blank">https://community.qlik.com/t5/QlikView-App-Development/To-Know-Last-Refreshed-Date-of-Excel-CSV-and-Qvd-s/td-p/1057874</A></LI><LI><A href="https://community.qlik.com/t5/QlikView-Scripting/Incremental-Load-of-New-Files-Only/td-p/865069" target="_blank">https://community.qlik.com/t5/QlikView-Scripting/Incremental-Load-of-New-Files-Only/td-p/865069</A></LI><LI><A href="https://community.qlik.com/t5/New-to-QlikView/How-to-load-latest-excel-from-the-folder/td-p/40984" target="_blank">https://community.qlik.com/t5/New-to-QlikView/How-to-load-latest-excel-from-the-folder/td-p/40984</A></LI></UL> Sun, 18 Nov 2018 15:48:37 GMT Gysbert_Wassenaar 2018-11-18T15:48:37Z https://community.qlik.com/t5/QlikView/Load-data-that-is-not-yet-read/m-p/1508643#M750458 <P><SPAN class="">Hi guys,<BR />In a directory I get daily (CSV) files that contain data that I need to add to my existing data.<BR /><SPAN>How can I do this without reading all the data in all csv files?</SPAN></SPAN></P><P><SPAN class=""><SPAN>Thanks for your help</SPAN></SPAN></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Load-data-that-is-not-yet-read/m-p/1508643#M750458 odaher123 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Load-data-that-is-not-yet-read/m-p/1508645#M750459 <P>You can load all the csv files once into one table and then store that table into a qvd file. The next time you need only load the latest csv file and all the data from the qvd file and then store the complete table again in the qvd file. It's called incremental loading. The trick then is to know which csv file is the latest. Perhaps your csv files have a date in their file name and you can use that. Or you could check the creation times of the files. Here are some discussions on that topic:</P><UL><LI><A href="https://community.qlik.com/t5/QlikView-App-Development/Load-the-latest-file-of-a-folder/td-p/192461" target="_blank">https://community.qlik.com/t5/QlikView-App-Development/Load-the-latest-file-of-a-folder/td-p/192461</A></LI><LI><A href="https://community.qlik.com/t5/QlikView-App-Development/To-Know-Last-Refreshed-Date-of-Excel-CSV-and-Qvd-s/td-p/1057874" target="_blank">https://community.qlik.com/t5/QlikView-App-Development/To-Know-Last-Refreshed-Date-of-Excel-CSV-and-Qvd-s/td-p/1057874</A></LI><LI><A href="https://community.qlik.com/t5/QlikView-Scripting/Incremental-Load-of-New-Files-Only/td-p/865069" target="_blank">https://community.qlik.com/t5/QlikView-Scripting/Incremental-Load-of-New-Files-Only/td-p/865069</A></LI><LI><A href="https://community.qlik.com/t5/New-to-QlikView/How-to-load-latest-excel-from-the-folder/td-p/40984" target="_blank">https://community.qlik.com/t5/New-to-QlikView/How-to-load-latest-excel-from-the-folder/td-p/40984</A></LI></UL> Sun, 18 Nov 2018 15:48:37 GMT https://community.qlik.com/t5/QlikView/Load-data-that-is-not-yet-read/m-p/1508645#M750459 Gysbert_Wassenaar 2018-11-18T15:48:37Z