Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
sunny_talwar

Add NoConcatenate after the table name

tbl_Jan:

NoConcatenate

LOAD .....

View solution in original post

6 Replies
sunny_talwar

Add NoConcatenate after the table name

tbl_Jan:

NoConcatenate

LOAD .....

swuehl
MVP
MVP

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
Partner - Contributor III
Partner - Contributor III

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

swuehl
MVP
MVP

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
Not applicable
Author

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

and try it step by step.

regards and thanks everybody,

sam