Skip to main content Skip to complementary content

Comment table

Provides a way of displaying the table comments (metadata) from databases or spreadsheets.

Table names not present in the app are ignored. If multiple occurrences of a table name are found, the last value is used. The keyword can be used to read comments from a data source.

Syntax:  

comment [tables] tablelist using mapname

Arguments:  

Argument Description
tablelist (table{,table})
mapname The name of a mapping table previously read in a mapping LOAD or mapping SELECT statement.

Syntax:  

To set individual comments, the following syntax is used:

comment [table] tablename with comment

Arguments:  

Argument Description
tablename The name of the table that should be commented.
comment The comment that should be added to the table.

Example 1:  

Commentmap:

mapping LOAD * inline [

a,b

Main,This is the fact table

Currencies, Currency helper table

];

comment tables using commentmap;

Example 2:  

comment table Main with ‘Main fact table’;

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!