How to recode 15 brand to 4 brand using Map thru Excel file ?
I have below script , it does not give me any error :-
FROM mapsubbrand.xlsx (ooxml,embedded labels, table is [Sheet4]);
My excel file have below brand :-
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.