Concatenate table

[#1]

Good Morning Friends,

Can anyboady tell me what is the use of Concatenating the same table twice and in the sql statement, the where conditon is differs

Like

Test:

Load * from

D:/Test.qvd(QVD)

Test1:

Concatenate (Test)

Load * from

D:/Test.qvd(QVD)

Regards

Chriss

[Anonymous]

Well, you're creating one table from two different SQL statements.. selecting two different sets of the source table and concatenating them back into one table in QlikView.