Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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?

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Resident load table not loading

the table gets auto-concatenated, try

Final:

NOCONCATENATE

LOAD *

Resident SQL_table;

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Resident load table not loading

the table gets auto-concatenated, try

Final:

NOCONCATENATE

LOAD *

Resident SQL_table;

View solution in original post

Highlighted
Not applicable

Re: Resident load table not loading

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?