Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Comment Fieldlist not working

Hi

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 

ES 

UK 

US 

]; 

Data: 

LOAD * INLINE [ 

Code 

ES 

UK 

US 

]; 

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

2 Replies
vinieme12
Champion III
Champion III

not sure what exactly you are trying to do,

have you looked at the examples here?

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatement...

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
hector_munoz
Specialist
Specialist

Hi Karthick,

Try the following:

MAPPING LOAD * INLINE [

Comment, Desc

CountryCode, This is test1

Code, This is test2

];

Data:

LOAD * INLINE [

CountryCode

ES

UK

US

];

Data:

LOAD * INLINE [

Code

ES

UK

US

];

Comment fields using CommentTable;

I attach a sample.

Regards,

H