Alternate way for Union keyword in Qlikview

[sarfaraz_sheikh]

Dear All,

I want to know what is ulternate or equivalent option for UNION Like keyword in Qlikview.

Help would be much appreciated.

Sarfaraz

[qlikmsg4u]

SQL Union Equivalent in qlikview is Concatenate

ex:

Select * from Table1

Union

Select * from Table2

Load * from Table1

Concatenate

Load * from Table2

If both qlikview tables have same table names then Concatenate keyword not required

[qlikmsg4u]

Check this thread

Merging to SQL Tables (union way, vertically)

[marcus_malinow]

CONCATENATE

For example...

LOAD *

FROM TABLE1.QVD (qvd)

CONCATENATE

LOAD *

FROM TABLE2.QVD (qvd)

[sarfaraz_sheikh]

is this possible in Expression Level .........if yes then help would be much appreciated ...

Sarfaraz

[marcus_malinow]

Erm, not sure why you would want to do this, but I'd suggest providing some sample data and the results you are looking for.