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: 
wanyunyang
Creator III
Creator III

resident table

Hi guys,

In my data load editor, I want to write a SQL query based on another SQL query table, like:

table1:

SQL

SELECT...

FROM...

WHERE...;

table2:

SQL

SELECT...

FROM Resident table1

WHERE...;

LOAD... Resident table2;

What the grammar should be like?

12 Replies
OmarBenSalem

when you use resident load

it's load * resident table1;

without the from :

It's not from resident table1

but resident table1

sasiparupudi1
Master III
Master III

Concatenate in qlik view is >= to union all

If two tables have identical columns ,qlik automatically concatenates them .

use  Concatenate statement between 2 dis similar tables to force a union

MK_QSL
MVP
MVP

FROM keyword is wrong here...
Load * Resident Table1;