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?
table1:
SQL
SELECT...
FROM...
WHERE...;
table2:
NOCONCATENATE LOAD *
Resident table1
WHERE...;
table1:
SQL
SELECT...
FROM...
WHERE...;
Noconcatenate
table2:
Load * FROM Resident table1
WHERE...;
The following error occurred:
Invalid Path
What exactly you wrote? Can you provide screenshot here please?
table1:
SQL
SELECT...
FROM...
WHERE...;
table2:
NOCONCATENATE LOAD *
Resident table1
WHERE...;
Can I do GROUPBY() etc.?
you can do most sql operation on the resident tables
table2
Load
Count(Field1),
Sum(Field2),
Dim1,
Dim2
Resident table1
Where 1=1
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
ex:
Inner join(table1)
I'm sorry one more question:
Can I do something like:
Noconcatenate
table2:
(LOAD A,B
Resident table1)
UNION ALL
(LOAD a AS A, B
Resident table2);
Thanks!