topic Re: Combining data from 2 tables in QlikView

Combining data from 2 tables

Fri, 26 Jul 2013 09:18:04 GMT

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 — Fri, 26 Jul 2013 09:27:20 GMT

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 — Fri, 26 Jul 2013 09:49:08 GMT

Try this..

Load * from tableA;

Outer join

Load * from tableB;