13 Replies Latest reply: Jun 15, 2017 6:57 AM by Sunny Talwar RSS

    split field into specific sub categories

    Nicoals Martin

      Hello all,

       

      I'm struggling defining two subcategories depending on one field, during the LOAD process.

       

      The objective is quite simple (in bold) and should be classified thanks to "ifs" functions:

       

      ProductCategoriesColorModelMotor
      Ferrari458; red; V12; V6red458V12; V6
      BMWM5;blueblueM5
      MercedesA 100;  A class; A 300A classA 100; A300
      BMWM3; greengreenM8
      Renaultclioclio

       

      Note: the categories have no specific orders.

       

      Any any about how to do it?

       

      Many thanks in advance,

       

      Nicolas