Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am making a group using the item code but not able to get it.
===> If((WildMatch(Itemcode,'11*')) and(WildMatch(ItemCode,'90*')), 'Retail',
If((WildMatch(Itemcode,'13*')) and (WildMatch(Itemcode,'95*')),'Drinks')) AS GROUP1
I am trying the above code and it is not working.Please Help me out.
Hi
Try like this
If(WildMatch(Itemcode,'11*', '90*'), 'Retail',
If(WildMatch(Itemcode,'13*', '95*'),'Drinks')) AS GROUP1
Try like
If(WildMatch(Itemcode,'6*', '9*'), 'Retail',
If(WildMatch(Itemcode,'3*', '5*'),'Drinks')) AS GROUP1,
Try using the following code:
If((WildMatch(Itemcode,'11*')) or (WildMatch(ItemCode,'90*')), 'Retail',
If((WildMatch(Itemcode,'13*')) or (WildMatch(Itemcode,'95*')),'Drinks')) AS GROUP1
Hi
Try like this
If(WildMatch(Itemcode,'11*', '90*'), 'Retail',
If(WildMatch(Itemcode,'13*', '95*'),'Drinks')) AS GROUP1
If((WildMatch(Itemcode,'11*')=1) and(WildMatch(ItemCode,'90*')=1), 'Retail',
If((WildMatch(Itemcode,'13*')=1) and (WildMatch(Itemcode,'95*')=1),'Drinks')) AS GROUP1
It worked it...!!
Thanks A lot