topic Re: Comparing tables when doing a LOAD in QlikView

Comparing tables when doing a LOAD

richard_chilvers — Tue, 13 Nov 2012 14:11:07 GMT

I have table1 loaded from a QVD file with FIELD1, FIELD2, FIELD3, FIELD4.

I have a 2nd table with the same fields and I want to concatenate only records where the combination of values in FIELD1, FIELD2 and FIELD3 doesn't already exist.

I think this is rather like a PARTIAL LOAD (ie. add load) but with multiple EXISTS conditions.

Is this possible.

Or is there another way?

Thanks.

Re: Comparing tables when doing a LOAD

Gysbert_Wassenaar — Tue, 13 Nov 2012 14:28:38 GMT

Try like this:

Table1:

LOAD

autonumber(FIELD1&FIELD2&FIELD3) as Key,

FIELD1,

FIELD2,

FIELD3,

FIELD4

from ....;

Table2:

left join LOAD

autonumber(FIELD1&FIELD2&FIELD3) as Key,

FIELDx,

FIELDy,

FIELDz

from ....;

Re: Comparing tables when doing a LOAD

its_anandrjs — Tue, 13 Nov 2012 14:34:17 GMT

Hi,

Write some thing like in your script

table1:

Load

FIELD1,

FIELD2,

FIELD3,

FIELD4,

FIELD1& FIELD2&FIELD3 as Key

from your source;

table2:

concatenate

Load

FIELD1,

FIELD2,

FIELD3,

FIELD1& FIELD2&FIELD3 as Table2Key

from your source

where not Exists(key,Table2Key);

HTH

Regards,

Anand

Re: Comparing tables when doing a LOAD

richard_chilvers — Tue, 13 Nov 2012 15:16:41 GMT

Thanks for your prompt response.

Will try this - looks like it will work !

Regards

Re: Comparing tables when doing a LOAD

richard_chilvers — Tue, 13 Nov 2012 15:17:20 GMT

Thanks for your prompt response and helpful answer