Is it possible to do a incremental load from excel? Each month we have a new excel file with updates, wich means that the files will contain the same data. A distinct load will not work because the historic will sometimes change with one value. I want the qlik to only load the new records in the file/or changes.
Each month we will have a new column, for the below picture the next column "Month 7" will contain values for Month 7 since opening date. Dep, Club and openingdate will not change. I only want to load the "newest month".
If the prior month's data can also change (did I understand you correctly?), and you are loading from Excel, why would you want to load incrementally? Incremental load is most useful when loading large data sets, something like transactions data, there the model might contain say 20m rows, but you only want to load from the source, the 1,000 rows for the last day.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein