how to increment the file load ever month without overwriting existing file in Qlik sense
Need to add new file every month just keeping appending new data with the latest date. I have below query where it will load the data but it is overwriting the existing data. this query is currently run automatically as scheduled. Kind suggest how to increment so that it shouldn't be impacted old data.
let prevmon=date(addmonths(today(),-1),'MMM YYYY');
LOAD "As of Date", "xxxx", "xxx", "XXXX", "XXXX" FROM [lib://Source/SourceLanding/Reports/monthlyDetail report as of $(prevmon).xls] (biff, embedded labels, table is [qry For Comments$]);
if you wants to do incremental load. first you need to store your current file to qvd, the concatenate with current load. or if your volume isn't that much and your files are stored in the same folder, just load all your table with wildcard match.
