Ampersand with Applymap

[juleshartley]

Hi all,

I came across an odd issue today...

When using Applymap() with an '&' in the field being mapped, it gives an incorrect answer. 

Has anyone experienced this?

Thanks,
J

[sunny_talwar]

Would you be able to share an example of where the & is? Is it in the field from which you map from or is the & used in map to?

[juleshartley]

so the mapping load uses a text field to map to an id eg:

MapComID:

CompanyName, ID

John & James, 123

then applymap then using companyname...

[dplr-rn]

From what i know theres no issues with &. ran a simple test below

companymap:
mapping load * inline [
CompanyName, ID
John & James, 123
Jack,321
Jack & Jill, 456
]
;
Test:
load *,
ApplyMap('companymap',CompanyName,'')as ID;
Load * Inline [
CompanyName, Sales
John & James, 10000
Jack,1300
Jack & Jill, 1500

]
;

Output is correct

Most likely check your source file/tables. Seem to remember few threads where excel  messed something up resulting in issues which seemed like & issue you mentioned

[dplr-rn]

e.g.
https://community.qlik.com/t5/New-to-QlikView/Ampersand-in-text-string-causing-problems/td-p/552413