grouping in edit script

[Surya]

I have a 2 fields i need to grouping in edit script

field names are Material and finishing days

in the material the material code like 6-10 ,6-9,6-13,10-13 like

and finishing days 1-1000


here i want grouping

material other than 6-10 and days >30    //one group

material other than 6-9 and days >30     //one group

material other than 6-10 and days <=30    //one group

material other than 6-9 and days <=30     //one group

material has 6-9    //one group

material other than 6-9    //one group




How can i do
the two fields available in same table

[HirisH_V7]

Could you please post a sample data set and expected result.

[Surya · Accepted solution]

 load *, if(NOT WILDMATCH(MATERIAL_LONG_INV,'*6-10*') AND FINISHING_AGEING_DAYS_INV >30,'STRSALES', if(NOT WILDMATCH(MATERIAL_LONG_INV,'*6-10*') AND FINISHING_AGEING_DAYS_INV <=30,'STRPLANT', if(WILDMATCH(MATERIAL_LONG_INV,'*6-10*') ,'STRGAUCTION'), if(NOT WILDMATCH(MATERIAL_LONG_INV,'*6-9*') AND FINISHING_AGEING_DAYS_INV >30,'MLSMASALES', if(NOT WILDMATCH(MATERIAL_LONG_INV,'*6-9*') AND FINISHING_AGEING_DAYS_INV <=30,'MLSMAPLANT', if(WILDMATCH(MATERIAL_LONG_INV,'*6-9*' ,'MLSMAUCTION')))))AS SP_GROUP