Rename Fields not working properly with mapping load

Anonymous — Tue, 31 Jan 2017 08:40:58 GMT

I am currently facing an issue with using Rename fields using mapping load in qlik sense. The code goes as follows, it is pretty clear:

[Map_Fields]:
Mapping LOAD
Field1,
Field2

FROM [lib://abc.xlsx] (ooxml, embedded labels, table is Fields);

Rename fields using Map_Fields;

The issue is that the code is not working properly for some changes, for example when changing field name "Value" to "#Value", so adding special character #. Has any of you experienced this behavior (maybe you can list some other cases?) and eventually knows how to solve it?

The trouble also arises when using qualify - is there any way how to handle this smoothly and not completely manually? For example I have a field Customer, which then changes to Table1.Customer and suddenly my visualizations are ruined.

Thank you in advance for your help!

Simona

topic Rename Fields not working properly with mapping load in App Development

Rename Fields not working properly with mapping load