UnMatching Records to be append

[Anonymous]

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..

[jagan · Accepted solution]

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.

[jyothish8807]

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

[jagan]

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.

[jyothish8807]

Thanks alot Jagan

Regards

KC