Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to make a group of item code using wild match function with their respective item names.
Eg: if(wildmatch(Itemcode,'01*'),Itemname) as RawMaterial,
if(wildmatch(Itemcode,'02*'),Itemname) as Clothing,
if(wildmatch(Itemcode,'03*'),Itemname) as Fuel,
if(wildmatch(Itemcode,'04*'),Itemname) as Paper,
if(wildmatch(Itemcode,'05*'),Itemname) as Machine,
The problem where i am stuck is that I need to make an another group where every Item Name Starting with ItemCode '07*' till '99' need to come under a single group.
Note:The item Code is alpha-numeric.
I have tried it using the below code but not able to get it.
===> if(WildMatch(ItemCode >='07*' or ItemCode <='99'),Itemname) as STORES &Spares,
Please help me out.......!!!!!!!!!!!!!!
small correction in above gysberts exp ..(Closing bracket for num())
If( Num(Left(ItemCode,2),'00' ) >= 07 and Num(Left(ItemCode,2),'00') <= 99, Itemname) as STORES&Spares
Hi atulshishodia,
Try the below:
if(WildMatch(ItemCode >='07*' or ItemCode <='99'),Itemname) as [STORES &Spares],
Hope this will helps.
Perhaps like this:
If( Num(Left(ItemCode,2)) >= 7 and Num(Left(ItemCode,2)) <= 99, Itemname) as STORES&Spares
ok i will try it now and let you know!!
Thanks
small correction in above gysberts exp ..(Closing bracket for num())
If( Num(Left(ItemCode,2),'00' ) >= 07 and Num(Left(ItemCode,2),'00') <= 99, Itemname) as STORES&Spares
Fixed. Thanks!