Saving 2 tables to 1 qvd

[#1]

Hi All,

I have a qlikview document that grabs data from a database and then saves it to a qvd. I would like to add another SQL query in, which I did but I want both "tables" to be saved in the same QVD and omit duplicates when being saved.

Table1:
SELECT * 
FROM Table1;
SELECT *
FROM Table2;

STORE * FROM Table1 INTO [table1.qvd];

Any help would be appreciated!

[sunny_talwar]

May be this:

1. Table1: 
2. SELECT *  
3. FROM Table1;
4. 
   
5. Concatenate (Table1) 
6. SELECT * 
7. FROM Table2; 
8.  
9. STORE * FROM Table1 INTO [table1.qvd]; 

[swuehl]

You can't filter the records in the STORE statement itself to remove duplicates, so you would need this in an additional temporary resident table load or when you are loading in from your table source.

You can use a LOAD DISTINCT ...  or potentially a WHERE clause with an Exists() condition to remove your duplicates.

[HirisH_V7]

Hi,

Data:
Load table1;

Concatenate

Load table2;

Main:
Load  Distinct
*
Resident Data;

Store Main into Main.Qvd;

HTH,

Hirish