Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

obtaining unmatched records from two tables

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

1 Reply
Nicole-Smith

See the Load Script in the attached.