Resident - Table not found

[Anonymous]

Hi,

i test the command Resident and get an error that the table is not found. Why?

Regards,

sam

[sunny_talwar · Accepted solution]

Add NoConcatenate after the table name

tbl_Jan:

NoConcatenate

LOAD .....

[swuehl]

Because Qlik Auto-concatenate tables with same number and names of fields.

Use NOCONCATENATE LOAD prefix to avoid this:

tbl_Jan:

NOCONCATENATE

LOAD ....

[sunny_talwar]

Do the same thing for tbl_mrz

[handry_orozco]

All Table contatenacete and your result is the table (tbl_apr), the firts table load, use noconcatenate or use resident tbl_apr

[swuehl]

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.

[Anonymous]

I want this How to create new tables from existing data?

and try it step by step.

regards and thanks everybody,

sam