Usually I don't struggle with the ApplyMap function, has been working great. However, when I try to use it with an INLINE lookup such as the example below, it will not map to AAContactNoDesc. Am I doing something wrong here?
MAPPING LOAD * INLINE
'0113 438 0120','Flying to Mars'
'0330 780 7436','Flying to the Moon'];
ApplyMap('MAP_AACONTACTNO',AAContactNumber) as AAContactNoDesc,
Thanks Deepak, that was indeed a typo, which I'll edit out. I did try re-running though just in case, and the behaviour is that AAContactNoDesc is shown with the number in it, not the description as one would expect.
I tried it without the single quote and use the 3rd parameter to bucket the unmapped which is useful thanks. However, instead of getting all telephone numbers back, I am now getting UNKNOWN for everything.
ApplyMap('MAP_AACONTACTNO',AAContactNumber,'UNKNOWN') as AAContactNoDesc,
Is this a data type issue possible? The join key is clearly the contact no, is QV treating it as text or a number? Should I force it to be text like text(AAContactNumber) to ensure the join/mapping works? or?
Thanks Ahmar, I tried this mod and it does not affect the outcome. I also tried a field alias and re-inserting the single quotes. Still not getting the description to come through though. At the moment, it is still only displaying -
for all values despite the fact that the numbers are the same and the description should be coming through.