topic Re: Comment Fieldlist not working in QlikView

Comment Fieldlist not working

Anonymous — Sun, 12 Feb 2017 05:02:33 GMT

Basically, I am trying to use "comment fieldlist using mapname" syntax

I am using the following script to comment multiple fields using mapping table. But this is not working. Please help:

CommentTable:

MAPPING LOAD * INLINE [

Comment, Desc

CountryCode, This is test1

Code, This is test2

];

Comment field CountryCode using CountryNamesMap;

Data:

LOAD * INLINE [

CountryCode

];

Data:

LOAD * INLINE [

Code

];

I know we can do this using comment field CountryCode with "This is test1". But I am trying to do this with mapping table.

Is it possible to use a set of fields to pick its respective comments from a mapping table.

Thanks

vinieme12 — Sun, 12 Feb 2017 08:58:40 GMT

not sure what exactly you are trying to do,

have you looked at the examples here?

hector_munoz — Sun, 12 Feb 2017 09:00:44 GMT

Hi Karthick,

Try the following:

MAPPING LOAD * INLINE [

Comment, Desc

CountryCode, This is test1

Code, This is test2

];

Data:

LOAD * INLINE [

CountryCode

];

Data:

LOAD * INLINE [

Code

];

Comment fields using CommentTable;

I attach a sample.

Regards,