Map commend for Flag hot selling items

[#1]

Hi All

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,1

];

In my Tab = TS , i add below script :-

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

I get error msg , parameter need 2 to 3....

[tresesco · Accepted solution]

Try removing extra single quotes like:

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

[#3]

Thank Tres