Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Comment field - use

Hi All,

Can someone plz let me know the use of Comment field keyword syntax in the script.?

Thanks in advance..

1 Solution

Accepted Solutions
6 Replies
ashfaq_haseeb
Champion III
Champion III

Hi

try using QlikView help instead bu QlikView F1 in your QlikViewapplication.

Below definition is from QlikView help.

Comment Field

Provides a way of displaying the field comments (metadata) from databases and spreadsheets. Field names not present in the document will be ignored. If multiple occurrences of a field name are found, the last value is used.

The keyword can be used to read comments from a data source using the following syntax:

comment *fieldlist using mapname

*fieldlist is a comma separated list of the fields to be commented. Using * as field list indicates all fields. The wildcard characters * and ? are allowed in field names. Quoting of field names may be necessary when wildcards are used.

mapname is the name of a mapping table previously read in a mapping load or mapping select statement (see Mapping).

The map table used should have two columns, the first containing field names and the second the comments.

To set individual comments the following syntax is used:

comment fieldname with comment

fieldname is the name of the field that should be commented.

comment is the comment that should be added to the field.

Example 1:

commentmap:

mapping load * inline [

a,b

Alpha,This field contains text values

Num,This field contains numeric values

];

comment fields using commentmap;

Example 2:

comment field Alpha with AFieldContainingCharacters;

comment field Num with A field containing numbers’;

comment Gamma with 'Mickey Mouse field';

Regards

ASHFAQ

its_anandrjs

See the below examples from the help

Example1:

commentmap:

mapping load * inline [

a,b

Alpha,This field contains text values

Num,This field contains numeric values

];

comment fields using commentmap;

Example2:

comment field Alpha with AFieldContainingCharacters;

comment field Num with A field containing numbers’;

comment Gamma with 'Mickey Mouse field';

Not applicable
Author

Hi Anand,

Thanks for your reply. I have gone through the example.. i wanted to know in whihc scenario this can be used and what could be the purpose of this Commnet field keyword in qlikview...

its_anandrjs

Comment table and field is used to define the comments for the fields and nature of the fields in the table with its descriptions.

If you read the below document will help you

What is use of comment table and comment field statements?

Not applicable
Author

Test.pngIt can be seen in the Table viewer when you hover over the field name

rustyfishbones
Master II
Master II

Hi,

This video may help you

Qlikview Add Comments to Tables by RFB 175 - YouTube

Regards

Alan