Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can someone plz let me know the use of Comment field keyword syntax in the script.?
Thanks in advance..
Hi
try using QlikView help instead bu QlikView F1 in your QlikViewapplication.
Below definition is from QlikView help.
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
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';
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...
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
It can be seen in the Table viewer when you hover over the field name