Extract Comments in the Schema of a Table

[Prakhar1]

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.

[CGnaba]

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]

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.