Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
Anyone has a quick script to do incremental load based on file names where the file names have dates in it.
Example of files names:
2015-10-01-MainSales..xlsx
2015-10-02-MainSales..xlsx
2015-10-03-MainSales..xlsx
Thxs,
Alec
Your dates from the filename could you extract with filebasename, maybe like:
date(date#(left(filebasename(), 10), 'YYYY-MM-DD'), 'YYYY-MM-DD')
and various examples and explanations to incemental loads will you find here:
CRUDhelper framework - Incremental loads with ease
- Marcus
Your dates from the filename could you extract with filebasename, maybe like:
date(date#(left(filebasename(), 10), 'YYYY-MM-DD'), 'YYYY-MM-DD')
and various examples and explanations to incemental loads will you find here:
CRUDhelper framework - Incremental loads with ease
- Marcus
thank you Marcus..