Problem in Set Analysis

[#1]

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.

[senpradip007]

Try like

If(WildMatch(Itemcode,'6*', '9*'), 'Retail',

       If(WildMatch(Itemcode,'3*', '5*'),'Drinks'))  AS  GROUP1,

[#3]

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

[MayilVahanan · Accepted solution]

Hi

Try like this

If(WildMatch(Itemcode,'11*', '90*'), 'Retail',

       If(WildMatch(Itemcode,'13*', '95*'),'Drinks'))  AS  GROUP1

[sagarkharpude]

If((WildMatch(Itemcode,'11*')=1)  and(WildMatch(ItemCode,'90*')=1), 'Retail',

       If((WildMatch(Itemcode,'13*')=1) and (WildMatch(Itemcode,'95*')=1),'Drinks'))  AS  GROUP1

[#6]

It worked it...!!

Thanks A lot