LookUp table show data who matches and who are not matches

[abhi144]

I have a csv file in which two field are ShopNo and ShopId. From search i'm getting ShopNo and ShopIdinDevice so i wanted a lookup table to show like-

ShopNo ShopIdinDevice Shopid

So i can compare for which ShopNo, ShopIdinDevice and ShopId is different. What should be search command for this?
Any suggestion will be appreciated.

[somesoni2]

This could be as simple as below:-

your base search giving ShopNo,ShopIdinDevice | lookup youlookup.csv ShopNo OUTPUT ShopId