In my data load editor, I want to write a SQL query based on another SQL query table, like:
FROM Resident table1
LOAD... Resident table2;
What the grammar should be like?
Load * FROM Resident table1
The following error occurred:
What exactly you wrote? Can you provide screenshot here please?
FROM keyword is wrong here... Load * Resident Table1;
NOCONCATENATE LOAD *
Can I do GROUPBY() etc.?
you can do most sql operation on the resident tables
Group By Dim1, Dim2
Order by Dim1,Dim2
Why are my table1 and table2 still connected with NOCONCATENATE?
noconcatenate is used when you do not want qlik to concatenate(union) identical tables together
You can replace it with
I'm sorry one more question:
Can I do something like:
(LOAD a AS A, B
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
when you use resident load
it's load * resident table1;
without the from :
It's not from resident table1
but resident table1
Retrieving data ...