Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mrjohn23
Creator III
Creator III

Resident load table not loading

Hello, I'm having trouble with Resident load

Syntax

SQL_table:

SQL

select distint *

from table;

Store SQL_Table into xxxxx;

Final:

LOAD *

Resident SQL_table;

drop table SQL_table;

Table Final does not exitst, why?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

the table gets auto-concatenated, try

Final:

NOCONCATENATE

LOAD *

Resident SQL_table;

View solution in original post

2 Replies
swuehl
MVP
MVP

the table gets auto-concatenated, try

Final:

NOCONCATENATE

LOAD *

Resident SQL_table;

Not applicable

you hav 2 tables that are exactly the same so QlikView will automatically concetnate them together - when you look at the table you ahve, it will ahve twice the amount of entries it should have

what is the purpsoe of doing the resident load after the intial load?