Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Combining data from 2 tables

Hi there,

I have a task to combine data from two tables in Qlikview. I am new to Qlikview and have a strong SQL background/

In normal SQL it would be:

SELECT *

FROM tableA

UNION ALL

SELECT *

FROM tableB

How do I achieve this inside Qlikview ?

Many thanks.

Regards,

Mpho

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Combining data from 2 tables

Concatenate the two tables:

Table1:

Load * from tableA;

concatenate(Table1)

Load * from tableB;

But if you're getting the data from one sql database you can simply use your current sql statement:

Table1:

SQL select * from tableA

union select * from tableB;


talk is cheap, supply exceeds demand
Highlighted
Specialist II
Specialist II

Re: Combining data from 2 tables

Hi

Try this..

Load * from tableA;

Outer join

Load * from tableB;