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.
This could be as simple as below:-
your base search giving ShopNo,ShopIdinDevice | lookup youlookup.csv ShopNo OUTPUT ShopId