Concatenating tables

[markgraham123]

Hi all,

I have 2 tables with same no. of fields and field names.

Table 1 contains the data of 2014 year.

Table 2 contains the data of 2013 year.

Can i use the below code to combine both into single table????

Table3:

Load Field1, Field2, Field3 from

Table1.Qvd;

Concatenate

Load Field1, Field2, Field3 from

Table2.Qvd;

Store Table3 into 2013&2014 Data.qvd

[jolivares]

if you have two identical tables, you only have to load one after the other to concatenate in QV without express with the command "concatenate"

Your script is correct, you can even dispense the command "concatenate"

[miguelbraga]

If there is a different key using the same date, there won't be a duplicate values For example, there can be 2 products qith 2 different ID's made in the same day

[rwunderlich]

Concatenating does not filter duplicates. So yes, if 12/31/2013 exists (overlap) in both source tables then you will have duplicates. If you want to eliminate the duplicates, you have two choices. If every row contains unique values, you can use

LOAD DISTINCT ....

If every row contains a unique key, and that key is the identical on the duplicates, you can use the exists() function.

Load Field1, Field2, Field3 from

Table2.Qvd

WHERE NO EXISTS(Key);

-Rob

http://masterssummit.com

http://qlikviewcookbook.com