Comparing tables when doing a LOAD

[richard_chilvers]

Hi

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.

[Gysbert_Wassenaar]

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

[its_anandrjs · Accepted solution]

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

[richard_chilvers]

Thanks for your prompt response.

Will try this - looks like it will work !

Regards

[richard_chilvers]

Thanks for your prompt response and helpful answer