Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Hi
Try this..
Load * from tableA;
Outer join
Load * from tableB;