Discussion Board for collaboration related to QlikView Deployment.
Hi, I need to load, in ETL phase, a table that is the result of a MINUS (logically meaning) between 2 tables.
Which is the right command for this statement?
Thanks in advance
You mean records that exist in one or other, but not both?
I think you have to join the tables and then filter records (bold)
load * inline [
f1, f2, f3
NoConcatenate load * inline [
NoConcatenate load *, 1 as t1 Resident t1;
join (tmp) load *, 1 as t2 Resident t2;
DROP Table t1, t2;
NoConcatenate load * Resident tmp where t1=1 and IsNull(t2);
DROP Table tmp;
I need to get records that are only in one table and not in the other one.
This script performs TAB2 - TAB1
load *inline [
Load * Resident TAB2 Where Not Exists(country,country1);
Drop Tables TAB1,TAB2;
Load * Where Not Exists(country);
Drop Table TAB1;