Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
My ApplyMap which looks like this:
ApplyMap('T1',LANDISO & BLTSPRISO & BLTGS1,'AT' & 'DEAT' & BLTGS1) as TextG1
doesn't work as expected.
For values where LANDISO and BLTSPRISO and BLTGS1 are in my Mapping table it works fine but if the value isn't in my mapping table, T1 should map on 'AT' & 'DEAT' & BLTGS1 which doesn't work..
Any ideas?
Regards, Gf
>>but if the value isn't in my mapping table, T1 should map on...
I think you may be misunderstanding the third parameter of ApplyMap(). It is simply a value that is returned if there is no match in the mapping table. To map a different value, you could use this:
ApplyMap('T1', LANDISO & BLTSPRISO & BLTGS1,
ApplyMap('T1', 'AT' & 'DEAT' & BLTGS1, 'No Match')) as TextG1
>>but if the value isn't in my mapping table, T1 should map on...
I think you may be misunderstanding the third parameter of ApplyMap(). It is simply a value that is returned if there is no match in the mapping table. To map a different value, you could use this:
ApplyMap('T1', LANDISO & BLTSPRISO & BLTGS1,
ApplyMap('T1', 'AT' & 'DEAT' & BLTGS1, 'No Match')) as TextG1