How to use Map to filter hot selling items ?

[#1]

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,

[tresesco · Accepted solution]

Hi,

Try this:

  ApplyMap('HOTMAP', Model) AS HOT_MAP,

[#3]

Hi tres

Thank you it work.

Paul