Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
when you use resident load
it's load * resident table1;
without the from :
It's not from resident table1
but resident table1
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
FROM keyword is wrong here...
Load * Resident Table1;