topic Re: UnMatching Records to be append in QlikView

UnMatching Records to be append

Anonymous — Mon, 20 Oct 2014 03:18:38 GMT

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

Re: UnMatching Records to be append

jagan — Mon, 20 Oct 2014 03:24:27 GMT

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.

Re: UnMatching Records to be append

jyothish8807 — Mon, 20 Oct 2014 04:37:51 GMT

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

Re: UnMatching Records to be append

jagan — Mon, 20 Oct 2014 05:11:50 GMT

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.

Re: UnMatching Records to be append

jyothish8807 — Mon, 20 Oct 2014 05:21:24 GMT

Thanks alot Jagan

Regards