Thanks @bowesmana - mvmap so it iterates like a for loop and checks. What if I want to do multiple checks. Example, I want to check for different regions. mvcount(Region)>1, mvmap(Region, if(match(Region, "(?i)bangalore"), "Bangalore", null()) Here it iterates and checks for banglore. What if I want to check for Singapore , USA , China and so on. ? Its becoming quite challenging, please help me Example : Test_loc_method2 is the output I want from Region (mv field) Region Test_loc_method2 sh Bangalore Test Chennai Hyderbad Bangalore test China 1 India China Loc USA 2 London USA
... View more