Discussion Board for collaboration on QlikView Scripting.
After loading two tables I want to append into second table rows with keys of first table that not exist in second table.
How can I do this using EXISTS Function?
Please see small example attached.
Try this Script:
LOAD id as idCheck,
LOAD * INLINE [
t2: // Contains less rows than t1
// Trying to upload into t2 the absent keys from t1
idCheck as id,
b as c
Where not Exists (id, idCheck);
DROP Table t1;
Output will look like this:
I understood the idea. But t1 and t2 have to be linked by 'id'.
Are you trying to merge them into one table or keep two tables?
T2 with T1 and T2 Data
T1 with T1 Data and
which one are you trying to achieve?
load idCheck as id, b
RENAME Table t to t1;