2 Replies Latest reply: Dec 16, 2013 2:44 AM by Paul Yeo RSS

    How to use Map to filter hot selling items ?

      Hi All

       

      After tres have help me on my first post . now i need the filter to be more advance. let me share with you :-

       

      Now i manually tick on my excel file column Hot = 1 for those items is hot selling.

       

       

      I want to replace by load script , using map command for doing this .

       

       

      So i create a map script :-

       

       

      HotMap:

       

       

      mapping LOAD * INLINE [

      OldCode,NewCode

       

       

      TS1070,1

      TS1070i,1

      TS1100,1

      TS1100i,2

       

       

      ];

       

       

      In my Tab = TS , i add below script , which is working fine after tres advise:-

       

       

        ApplyMap('HOTMAP', Model,'1') AS HOT_MAP,

       

       

      when i list filed = HOT_MAP , i wanted to see there is 1 and 2 value. so when i click on 1 it will list 3 items and click on 2 it will list 1 items.

       

       

      My question is how to modify my below script to achieve this ?

       

       

        ApplyMap('HOTMAP', Model,'1') AS HOT_MAP,