Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i test the command Resident and get an error that the table is not found. Why?
Regards,
sam
Add NoConcatenate after the table name
tbl_Jan:
NoConcatenate
LOAD .....
Add NoConcatenate after the table name
tbl_Jan:
NoConcatenate
LOAD .....
Because Qlik Auto-concatenate tables with same number and names of fields.
Use NOCONCATENATE LOAD prefix to avoid this:
tbl_Jan:
NOCONCATENATE
LOAD ....
Do the same thing for tbl_mrz
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.
edit:
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,
sam