Discussion board where members can get started with Qlik Sense.
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?
Go to Solution.
NOCONCATENATE LOAD *
Load * FROM Resident table1
The following error occurred:
What exactly you wrote? Can you provide screenshot here please?
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