topic Re: Ampersand with Applymap in App Development

Ampersand with Applymap

juleshartley — Sat, 16 Nov 2024 06:51:13 GMT

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

Re: Ampersand with Applymap

sunny_talwar — Tue, 15 Jan 2019 12:00:49 GMT

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?

Re: Ampersand with Applymap

juleshartley — Tue, 15 Jan 2019 12:20:00 GMT

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...

Re: Ampersand with Applymap

dplr-rn — Tue, 15 Jan 2019 20:12:58 GMT

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

Re: Ampersand with Applymap

dplr-rn — Tue, 15 Jan 2019 20:14:27 GMT

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