Discussion board where members can learn more about Qlik Sense App Development and Usage.
I currently have an excel file attached that will map our database field names to the business names. That works fine.
(ooxml, embedded labels, table is Aliases);
Rename Fields using [Alias Fields];
I would like to take it a step further and populate the description of the field as well. Does anyone have any examples on how to accomplish this?
Thanks in advance
Go to Solution.
The mapping-statement is missing:
[Comment Fields]:MAPPING LOAD "FieldName", "Comment"FROM [lib://AmerisureData/Warehouse\AWHColumnComments.xlsx](ooxml, embedded labels, table is Aliases);
Comment fields using [Comment Fields];
It's the same mapping-logic. Here an example from the help:
mapping load * inline [
Alpha, Dieses Feld enthält Textwerte
Num, Dieses Feld enthält numerische Werte
comment fields using KommentarMap;
Thanks for your response Marcus. i'm not sure about your browser but mine seems to be showing this in another language? Was that the intent?
The intention was to show that with the same mapping-approach like for the renaming the fields could be enriched with comments and/or tags which could be used like here described: Comments, Tags, and Documentation
So the English translation to your example is
Alpha, This Field Contains Text Values
Num, This Field Contains numerical values
comment fields using CommentMap;
like in this link Correct? I'll give it a try. Thanks!
ok, I tried it and I'm getting the below error
What am I doing wrong?
Mapping table 'Comment Fields' not found: Comment fields using [Comment Fields]
[Comment Fields]:LOAD "FieldName", "Comment"FROM [lib://AmerisureData/Warehouse\AWHColumnComments.xlsx](ooxml, embedded labels, table is Aliases);
That worked, thanks so much!
This worked but we updated to April 2018 and now it no longer populates. Is anyone having any Issues with it after the update?