Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
BjoernWollny
Contributor III
Contributor III

Comment of table - how to save/where to find in QVD

Hello,

in order to have a better overview of our used tables and fields, I started to create comments for each table and each field, by using

comment <TableName> with 'Comment';

comment <FieldName> with 'Comment';

 

For fields everything works well. I see the comments within the data model editor and also I can find the comment within the XML header of the QVD.

But I cannot find the comment of a table. Did I missed something?

 

Many thanks in advance and best regards!

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
LDR
Creator II
Creator II

Hi @BjoernWollny 

I was searching for the same question and thanks to your post and after reading QS help I found that the right command is:

Comment Table <TableName> With 'Your comments, descriptions for the table';

Once the table is stored in QVD format then the next step is to get access to our comment:

LOAD
QvBuildNo,
CreatorDoc,
CreateUtcTime,
SourceFileSize,
"TableName",
RecordByteSize,
NoOfRecords,
Offset,
"Length",
"Comment", //In this field we can find our comments.
%Key_QvdTableHeader_B94FCCAC68ED3E20
FROM [lib://YourPath/QVDFileName.qvd](XmlSimple, table is QvdTableHeader);

 

I can imagine you found the solution however, I thought it could be useful for the rest of this amazing community. 

Regards

View solution in original post

1 Reply
LDR
Creator II
Creator II

Hi @BjoernWollny 

I was searching for the same question and thanks to your post and after reading QS help I found that the right command is:

Comment Table <TableName> With 'Your comments, descriptions for the table';

Once the table is stored in QVD format then the next step is to get access to our comment:

LOAD
QvBuildNo,
CreatorDoc,
CreateUtcTime,
SourceFileSize,
"TableName",
RecordByteSize,
NoOfRecords,
Offset,
"Length",
"Comment", //In this field we can find our comments.
%Key_QvdTableHeader_B94FCCAC68ED3E20
FROM [lib://YourPath/QVDFileName.qvd](XmlSimple, table is QvdTableHeader);

 

I can imagine you found the solution however, I thought it could be useful for the rest of this amazing community. 

Regards