topic Re: Mapping Column names and descriptions in App Development

Mapping Column names and descriptions

Anonymous — Tue, 13 Mar 2018 18:37:43 GMT

I currently have an excel file attached that will map our database field names to the business names. That works fine.

[Alias Fields]:

Mapping LOAD

OldName,

NewName

FROM [lib://AmerisureData/Warehouse\AWHColumnAliases.xlsx]

(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

Re: Mapping Column names and descriptions

marcus_sommer — Wed, 14 Mar 2018 12:30:21 GMT

It's the same mapping-logic. Here an example from the help:

Beispiel 1:

KommentarMap:

mapping load * inline [

a, b

Alpha, Dieses Feld enthält Textwerte

Num, Dieses Feld enthält numerische Werte

];

comment fields using KommentarMap;

- Marcus

Re: Mapping Column names and descriptions

Anonymous — Wed, 14 Mar 2018 12:38:35 GMT

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?

Re: Mapping Column names and descriptions

marcus_sommer — Wed, 14 Mar 2018 16:25:40 GMT

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

- Marcus

Re: Mapping Column names and descriptions

Anonymous — Wed, 14 Mar 2018 16:57:35 GMT

So the English translation to your example is

Example 1:

CommentMap:

mapping load * inline [

a, b

Alpha, This Field Contains Text Values

Num, This Field Contains numerical values

];

comment fields using CommentMap;

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/comment-table.h…

like in this link Correct? I'll give it a try. Thanks!

Re: Mapping Column names and descriptions

Anonymous — Thu, 15 Mar 2018 19:20:38 GMT

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);

Comment fields using [Comment Fields];

Re: Mapping Column names and descriptions

marcus_sommer — Fri, 16 Mar 2018 06:36:52 GMT

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];

- Marcus

Re: Mapping Column names and descriptions

Anonymous — Fri, 16 Mar 2018 12:46:45 GMT

That worked, thanks so much!

Re: Mapping Column names and descriptions

Anonymous — Fri, 22 Jun 2018 12:12:04 GMT

This worked but we updated to April 2018 and now it no longer populates. Is anyone having any Issues with it after the update?