How to use Map to filter hot selling items ?

Mon, 16 Dec 2013 06:32:24 GMT

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,

Re: How to use Map to filter hot selling items ?

tresB — Mon, 16 Dec 2013 07:12:28 GMT

Hi,

Try this:

ApplyMap('HOTMAP', Model) AS HOT_MAP,

Mon, 16 Dec 2013 07:44:31 GMT

Hi tres

Thank you it work.

Paul