Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator II
Creator II

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 II
Creator II

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...;

View solution in original post

wanyunyang
Creator II
Creator II

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 II
Creator II

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 II
Creator II

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!