Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this Mapping Table
Mapping Load * Inline [
XYZ [A],CityA
XYZ [B],CityB
];
This is giving me error due to square brackets, how can I achieve the results without removing the brackets as its in data itself.
Have you tried enclosing the text in single quotes, e.g.
Mapping Load * Inline [
'XYZ [A]','CityA'
'XYZ [B]','CityB'
];
?
You will need to escape the right square brackets by doubling them:
Mapping Load * Inline [
F1, F2
XYZ [A]],CityA
XYZ [B]],CityB
];
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
A third approach is using double-quotes instead of the square-brackets for the inline area, like:
Mapping Load * Inline "
XYZ [A],CityA
XYZ [B],CityB
";
- Marcus
Marcus, I like your solution better!
-Rob