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)