Mapping Inline Table - Qlik Community

neerajthakur · ‎2022-01-12

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.

Thanks & Regards,
Please Accepts as Solution if it solves your query.

rbartley · ‎2022-01-12

Have you tried enclosing the text in single quotes, e.g.

Mapping Load * Inline [

'XYZ [A]','CityA'

'XYZ [B]','CityB'

];

?

rwunderlich · ‎2022-01-12

You will need to escape the right square brackets by doubling them:

Mapping Load * Inline [
F1, F2
XYZ [A]],CityA
XYZ [B]],CityB
];

marcus_sommer · ‎2022-01-13

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

rwunderlich · ‎2022-01-13

Marcus, I like your solution better!

-Rob