Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
homersimpson
Creator III
Creator III

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 .....

View solution in original post

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
Partner

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.

homersimpson
Creator III
Creator III
Author

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

and try it step by step.

regards and thanks everybody,

sam