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:


      Ferrari458; red; V12; V6red458V12; V6
      MercedesA 100;  A class; A 300A classA 100; A300
      BMWM3; greengreenM8


      Note: the categories have no specific orders.


      Any any about how to do it?


      Many thanks in advance,