obtaining unmatched records from two tables

[#1]

Hi ,

There are two tables by name K1 and Gen file and I want to compare both the tables with K1 columns(Source Plant Code, Destination) and Gen file columns(Plant, ShipToPartyKey).

I want to fetch the records from K1 file where SourcePlantcode NOTEQUALTO Plant  and Destination NOTEQUALTO ShiptoPartyKey.

Iam attaching a sample file and the output that I need to get is there in Result tab(4 Source plantcodes and 4 destinations  in K1 are not matching with Gen file so I will be getting the output 4 records)

Kindly help me out regarding this query.

Regards,

Hari

[Nicole-Smith]

See the Load Script in the attached.