Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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...
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