QUESTION

[nevilledhamsiri]

Hi,

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

MC,M3,M4,FR,MS,HH,TC,PP,SA etc.

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.

Load,

Class_code,

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.

Thanks

Neille.

[passionate]

Try:

pick(Match(Class_code,'mc','m3','m4')+1,'nonmotor','motor','motor','motor')

[nevilledhamsiri]

Dear Pnkaj,

Thanks, It worked well.

[passionate · Accepted solution]

Hi Neville,

Please mark the answer correct if your query is resolved.

The thread can be closed.

Thanks and Regards,

Pankaj