Load Comments into a table

[Enno86]

Dear Qlikperts,

I have managed to enrich some table fields using the "comment field" function.

I also noticed, once the QVD is loaded to a new app, it will show these comments correctly in the datamodel view.

Question now is: is it possible to "collect" all comments from a table(s) and list them in a new table?

Would be happy about any input on this matter.

Thanks in advance.

MAP_COMMENT:

MAPPING 

LOAD 

*

INLINE 

[

        FIELD|                     FIELD COMMENT

    COPA_AWTYP.CE11000|    Referenzvorgang

    COPA_KOSTL.CE11000|    Kostenstelle

    ]

(DELIMITER IS '|');

COMMENT FIELD USING MAP_COMMENT;

[marcus_sommer · Accepted solution]

It should be possible. Open the qvd with an editor like Notepad++ and look for comment and/or any of the used terms like Kostenstelle and you should find a xml-area in which they are stored.

The above is just to get an idea how the data are stored and which part of them are relevant for the comments. To load the data use the table-wizard and choose xml as file-format and picking then the wanted parts - maybe in a second step, at first it might be simple to load all the xml stuff and look at it within n UI tables and going then further.

[Enno86]

LOAD
FieldName
Comment
FROM [lib://....qvd]
(XmlSimple, table is [QvdTableHeader/Fields/QvdFieldHeader]);

Thanks for the hint @marcus_sommer