applymap

[#1]

Hi,

I'm trying to use a map to add a description

here is my map:

MapTest:

MAPPING LOAD

        Num(@1),

     @2

FROM

$(CHEMIN)Data_to_Load\SIGNA_*.TXT

(txt, codepage is 1252, no labels, delimiter is ',', msq);

here is the applymap:

ApplyMap('MapTest',Num(Field1)) AS description

The issue is when there are no correspondence, it doesn't put the value from Field1 else it puts correctly the value of the map.

thanks

[kaushiknsolanki · Accepted solution]

Hi,

     Do you mean when there is no mapping apply, it shows nothing?

     If yes then this is correct, when you say system to map something but if you dont specify what to map with what, it will not map. It will only map where it maches the field value.

     Kindly give one example.

Regards,

Kaushik Solanki

[er_mohit]

ApplyMap('MapTest',[Num(@1)]) AS description

hope it helps

[Anonymous]

Hi

I have just started using ApplyMap() (I am a beginner) and I supply a default when no value is present:

ApplyMap('MarketMap', ValueToTest, 'Others') As Market,

This defaults 'Others' when no corresponding value is found.

Ian

[#5]

thanks for your help

now it works correctly with your solutions.