Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table1 having 10 columns & table 2 having 7 columns, where i need to compare 3 fields from both table. If the 3 fields are not matching with the second table 3 fields i need to append 7 columns to my table1. Please tell me if you have any idea..
Hi Pradeep,
Try like this
Data:
LOAD
*,
Dimension1 & '_' & Dimension2 & '_' & Dimension3 AS Key
FROM Table1;
Concatenate(Data)
LOAD
*
FROM Table2
WHERE NOT EXISTS (Key, Dimension1 & '_' & Dimension2 & '_' & Dimension3);
Note: Replace Dimension1, Dimension2 and Dimension3 with your matching fields.
If you want detailed help on this chec Exists() in Qlikview Help file (F1).
Hope this helps you.
Regards,
jagan.
Hi Pradeep,
Try like this
Data:
LOAD
*,
Dimension1 & '_' & Dimension2 & '_' & Dimension3 AS Key
FROM Table1;
Concatenate(Data)
LOAD
*
FROM Table2
WHERE NOT EXISTS (Key, Dimension1 & '_' & Dimension2 & '_' & Dimension3);
Note: Replace Dimension1, Dimension2 and Dimension3 with your matching fields.
If you want detailed help on this chec Exists() in Qlikview Help file (F1).
Hope this helps you.
Regards,
jagan.
Hi jagan,
Can you please let me know why you took both (Key, Dimension1 & '_' & Dimension2 & '_' & Dimension3) in NOT EXISTS condition? Both are the same fields?
Regards
KC
Hi Jyothish,
Key column is the key field in Table1, and Dimension1 & '_' & Dimension2 & '_' & Dimension3 is the key using which we are excluding the already loaded records.
Refer Qlikview Help file (F1) for detailed explanation.
Regards,
Jagan.
Thanks alot Jagan
Regards
KC