I have a facts table with a lot of rows! The columns are for example: Date, Sales, Amount...... and so on.
First I need to loop the table to get 12 weeks. And then do an incremental load to only load the new transactions into the table. How can I do this the best way?
Take a look into the last two link-blocks within this document: Advanced topics for creating a qlik datamodel which covers various approaches about incremental and optimized (qvd) loadings.
