Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

Resident - Table not found

Hi,

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

2017-01-17_20h02_35.jpg

2017-01-17_20h04_35.jpg

Regards,

sam

1 Solution

Accepted Solutions

Re: Resident - Table not found

Add NoConcatenate after the table name

tbl_Jan:

NoConcatenate

LOAD .....

6 Replies

Re: Resident - Table not found

Add NoConcatenate after the table name

tbl_Jan:

NoConcatenate

LOAD .....

MVP
MVP

Re: Resident - Table not found

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

Use NOCONCATENATE LOAD prefix to avoid this:

tbl_Jan:

NOCONCATENATE

LOAD ....

Re: Resident - Table not found

Do the same thing for tbl_mrz

handry_orozco
New Contributor III

Re: Resident - Table not found

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

MVP
MVP

Re: Resident - Table not found

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.

homersimpson
Contributor II

Re: Resident - Table not found

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

and try it step by step.

regards and thanks everybody,

sam

Community Browser