topic Re: Re: Comment field - use in QlikView

Comment field - use

Mon, 12 May 2014 07:55:00 GMT

Hi All,

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

Thanks in advance..

Re: Comment field - use

ashfaq_haseeb — Mon, 12 May 2014 08:00:05 GMT

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

Re: Comment field - use

its_anandrjs — Mon, 12 May 2014 08:05:48 GMT

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

Re: Comment field - use

Mon, 12 May 2014 08:30:17 GMT

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...

Re: Comment field - use

its_anandrjs — Mon, 12 May 2014 08:36:40 GMT

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?

Re: Re: Comment field - use

Mon, 12 May 2014 17:52:23 GMT

It can be seen in the Table viewer when you hover over the field name

Re: Comment field - use

rustyfishbones — Mon, 12 May 2014 18:13:29 GMT

Hi,

This video may help you

Qlikview Add Comments to Tables by RFB 175 - YouTube

Regards

Alan