This content has been marked as final. Show 3 replies
Appreciate, if looked in to how accurate it is written in the script!. There are number of products which are refered to as different classes such as
above are in a field which is named as class_code, when I load the said field, what I need is to catergorize them in to two main classes namely MO & NM thereby create a new field as MONM. Please see the way I have done.
if (Class_code='mc','motor',if(class_code='m3','motor',if(class_code='m4','motor,'nonmotor' as monm,
The issue is once it is done, catergorization is not properly done. Look forward to a reply.