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?

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

table1:

SQL

SELECT...

FROM...

WHERE...;

table2:

NOCONCATENATE LOAD *

Resident table1

WHERE...;

View solution in original post

12 Replies
MK_QSL
MVP
MVP

table1:

SQL

SELECT...

FROM...

WHERE...;

Noconcatenate

table2:

Load * FROM Resident table1

WHERE...;

wanyunyang
Creator III
Creator III
Author

The following error occurred:

Invalid Path

MK_QSL
MVP
MVP

What exactly you wrote? Can you provide screenshot here please?

sasiparupudi1
Master III
Master III

table1:

SQL

SELECT...

FROM...

WHERE...;

table2:

NOCONCATENATE LOAD *

Resident table1

WHERE...;

wanyunyang
Creator III
Creator III
Author

Can I do GROUPBY() etc.?

sasiparupudi1
Master III
Master III

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

;

wanyunyang
Creator III
Creator III
Author

Why are my table1 and table2 still connected with NOCONCATENATE?

sasiparupudi1
Master III
Master III

noconcatenate is used when you do not want qlik to concatenate(union) identical tables together

You can replace it with

ex:

Inner join(table1)

wanyunyang
Creator III
Creator III
Author

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!