i test the command Resident and get an error that the table is not found. Why?
Add NoConcatenate after the table name
Do the same thing for tbl_mrz
Because Qlik Auto-concatenate tables with same number and names of fields.
Use NOCONCATENATE LOAD prefix to avoid this:
All Table contatenacete and your result is the table (tbl_apr), the firts table load, use noconcatenate or use resident tbl_apr
And I think you actually do want to concatenate your sales fact in a single table.
Not sure what you want to do with your tbl_sumApr table though.
If you use NOCONCATENATE, your tables will link by a syn key. which is probably not what you want.
I want this How to create new tables from existing data?
and try it step by step.
regards and thanks everybody,
Retrieving data ...