5 Replies Latest reply: May 23, 2015 7:11 PM by PAUL YEO RSS

    How to recode 15 brand to 4 brand using Map thru Excel file  ?

    PAUL YEO

      Hi All

       

       

      I have below script , it does not give me any error :-

       

       

      MapBrand:

      Mapping LOAD

        [Brand_],

        [SubBrand_]

      FROM  mapsubbrand.xlsx (ooxml,embedded labels, table is [Sheet4]);

       

       

      My excel file have below brand :-

       

       

      Brand_ SubBrand_

      HAKKO HAKKO

      BECKHOFF BECKHOFF

      MITSUBISHI MITSUBISHI

      MITSUBISH MITSUBISHI

      GE FANUC GE FANUC

      GE GE FANUC

       

       

      My script when load raw data :-

      Applymap('MapBrand',(subfield(@282:298,' ',1)),@282:298) as [BRAND_],

       

       

      @282:298T as [bRAND_], // Pls note this field have more then 10 brand. I need to display only 4 brand.

       

       

      Now my issue is it display all the brand , I need you recode this filed BRAND_ only display 4 core brand , meaning i need it only display Beckhoff , Hakko , GE , Mitsubishi and Other ,Now it display all brand is wrong.

       

       

      Hope some one can advise me.

       

       

      Paul