Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

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
Honored Contributor III

Re: resident table

table1:

SQL

SELECT...

FROM...

WHERE...;

table2:

NOCONCATENATE LOAD *

Resident table1

WHERE...;

12 Replies
MVP
MVP

Re: resident table

table1:

SQL

SELECT...

FROM...

WHERE...;

Noconcatenate

table2:

Load * FROM Resident table1

WHERE...;

wanyunyang
Contributor

Re: resident table

The following error occurred:

Invalid Path

MVP
MVP

Re: resident table

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

sasiparupudi1
Honored Contributor III

Re: resident table

table1:

SQL

SELECT...

FROM...

WHERE...;

table2:

NOCONCATENATE LOAD *

Resident table1

WHERE...;

wanyunyang
Contributor

Re: resident table

Can I do GROUPBY() etc.?

sasiparupudi1
Honored Contributor III

Re: resident table

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
Contributor

Re: resident table

Why are my table1 and table2 still connected with NOCONCATENATE?

sasiparupudi1
Honored Contributor III

Re: resident table

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
Contributor

Re: resident table

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!

Community Browser