Combining data from 2 tables

[#1]

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

[Gysbert_Wassenaar]

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;

[nihhalmca]

Hi

Try this..

Load * from tableA;

Outer join

Load * from tableB;