topic Incremental Load based on file name containing a date in QlikView https://community.qlik.com/t5/QlikView/Incremental-Load-based-on-file-name-containing-a-date/m-p/1004475#M341277 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Anyone has a quick script to do incremental load based on file names where the file names have dates in it.</P><P></P><P>Example of files names:</P><P></P><P>2015-10-01-MainSales..xlsx</P><P>2015-10-02-MainSales..xlsx</P><P>2015-10-03-MainSales..xlsx</P><P></P><P>Thxs,</P><P>Alec</P></BODY></HTML> Sun, 01 Nov 2015 19:11:34 GMT alec1982 2015-11-01T19:11:34Z Incremental Load based on file name containing a date https://community.qlik.com/t5/QlikView/Incremental-Load-based-on-file-name-containing-a-date/m-p/1004475#M341277 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Anyone has a quick script to do incremental load based on file names where the file names have dates in it.</P><P></P><P>Example of files names:</P><P></P><P>2015-10-01-MainSales..xlsx</P><P>2015-10-02-MainSales..xlsx</P><P>2015-10-03-MainSales..xlsx</P><P></P><P>Thxs,</P><P>Alec</P></BODY></HTML> Sun, 01 Nov 2015 19:11:34 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-based-on-file-name-containing-a-date/m-p/1004475#M341277 alec1982 2015-11-01T19:11:34Z Re: Incremental Load based on file name containing a date https://community.qlik.com/t5/QlikView/Incremental-Load-based-on-file-name-containing-a-date/m-p/1004476#M341278 <HTML><HEAD></HEAD><BODY><P>Your dates from the filename could you extract with filebasename, maybe like:</P><P></P><P>date(date#(left(filebasename(), 10), 'YYYY-MM-DD'), 'YYYY-MM-DD')</P><P></P><P>and various examples and explanations to incemental loads will you find here:</P><P></P><P><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="4597" data-objecttype="102" href="https://community.qlik.com/docs/DOC-4597"><SPAN lang="EN-GB" style="font-family: 'Arial',sans-serif;">Incremental Load</SPAN></A></P><P><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="1870" data-objecttype="102" href="https://community.qlik.com/docs/DOC-1870"><SPAN lang="EN-GB" style="font-family: 'Arial',sans-serif;">Incremental Load Scenarios</SPAN></A></P><P><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="5371" data-objecttype="102" href="https://community.qlik.com/docs/DOC-5371"><SPAN lang="EN-GB" style="font-family: 'Arial',sans-serif;">CRUDhelper framework - Incremental loads with ease</SPAN></A></P><P></P><P>- Marcus</P></BODY></HTML> Sun, 01 Nov 2015 19:17:16 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-based-on-file-name-containing-a-date/m-p/1004476#M341278 marcus_sommer 2015-11-01T19:17:16Z Re: Incremental Load based on file name containing a date https://community.qlik.com/t5/QlikView/Incremental-Load-based-on-file-name-containing-a-date/m-p/1004477#M341279 <HTML><HEAD></HEAD><BODY><P>thank you Marcus.. </P></BODY></HTML> Mon, 02 Nov 2015 00:11:20 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-based-on-file-name-containing-a-date/m-p/1004477#M341279 alec1982 2015-11-02T00:11:20Z