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
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dee_patil
Contributor
Contributor

How to concatenate 2 joined tables from 2 sources

Hi,

We need to achieve below. Can somebody please help? 

A:
Load
C1,
C2
From QVD1;

Inner Join (A)
Load
C1,
C2
B:
Select
C1,
B1
From Table1;


C:
Load
C1,
C2
From QVD2;

Inner Join (C)
Load
C1,
C2
D : 
Select
C1,
D1
From Table2;

//Now we want to achieve below

concatenate A and C

Basically I need to concatenate 2 joined tables from 2 sources.

 

Thanks,

Dee

1 Solution

Accepted Solutions
mato32188
Specialist
Specialist

HI @dee_patil,

A:
Load
C1,
C2
From QVD1;

Inner Join (A)
Load
C1,
B1;
SQL
Select
C1,
B1
From dbTable1;

noconcatenate
C:
Load
C1,
C2
From QVD2;

Inner Join (C)
Load
C1,
D1;
SQL Select
C1,
D1
From dbTable2;

noconcatenate

Final:

Load * resident A concatenate Load * resident C; drop tables A,C;

BR

m

ECG line chart is the most important visualization in your life.

View solution in original post

2 Replies
mato32188
Specialist
Specialist

HI @dee_patil,

A:
Load
C1,
C2
From QVD1;

Inner Join (A)
Load
C1,
B1;
SQL
Select
C1,
B1
From dbTable1;

noconcatenate
C:
Load
C1,
C2
From QVD2;

Inner Join (C)
Load
C1,
D1;
SQL Select
C1,
D1
From dbTable2;

noconcatenate

Final:

Load * resident A concatenate Load * resident C; drop tables A,C;

BR

m

ECG line chart is the most important visualization in your life.

View solution in original post

dee_patil
Contributor
Contributor
Author

Thanks a lot Mato32188 for quick response. I will try this solution and will update.

Thanks,

Dee