3 Replies Latest reply: Aug 13, 2017 2:44 AM by Pankaj Thakur RSS

    QUESTION

    D.R.NEVILLE DHAMSIRI DHAMSIRI

      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.