1 Reply Latest reply: May 24, 2015 2:01 AM by PAUL YEO RSS

    How to add 1 more condition on my script for 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(@314:343,' ',1)),'OTHER') as [BRAND_],

       

       

      @314:343T as [desc],  // Pls note this field have more then 10 brand. But it cannot recode project sales. 

       

       

      @97:100T as [pro_cls],   // prro_cls = 3000 equal to project sales.

       

       

      Now my issue is all project sales recode into Other ,  i need to add one more condition into the below script, Project sales appear at pro_cls field = 3000 :-

       

       

      Applymap('MapBrand',(subfield(@314:343,' ',1)),'OTHER') as [BRAND_],

       

       

      Meaning , ask the above script found missing value at desc field , check pro_cls if = 3000 , recode BRAND_ = PROJECT. ( Now it recode at OTHER , which is wrong )

       

       

      Hope some one can advise me.

       

       

      Paul