Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Prakhar1
Creator III
Creator III

Extract Comments in the Schema of a Table

hi All,

is there is a way to extract the comments in the schema of table using talend.

if you refer my attached file you can see my columns have some descriptions in the "COMMENT" tab.

I want to extract that.

Please suggest some ideas for this.

Labels (2)
2 Replies
CGnaba
Contributor
Contributor

Hi ,

I think you could use the file property file linked to your table present in your workspace. The file <table>.item has XML content with an element feature for each row of your table schema. In the attribute comment , you will find the value of comment Talend tab.

In Talend you could create a job which use a tFileInputXML and extract this value (your job could make a copy to avoid reading a talend studio file).

 

thks

Prakhar1
Creator III
Creator III
Author

No I don't want a complex thing to do.

Never mind i found a table in my SAP BW system which contains these details so I am extracting it directly from there.