Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be this:
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.
Hi,
Data:
Load table1;
Concatenate
Load table2;
Main:
Load Distinct
*
Resident Data;
Store Main into Main.Qvd;
HTH,
Hirish