Get column names of Excel file in variable (Dynamic Schema for Excel)

[Anonymous]

Hi,

I am trying to get the column names that would be coming from the excel, will parse with the metadata stored in the database and remove the extra columns.

I am able to do the later things except getting the column names out of the dynamic schema.

Example if the Excel is having Id, Name, Age as three columns and metadata has Id and Name, I will have to remove the Age from the schema before loading. I am able to remove the age, however I am unable to get the column name list out of tExcelInput.

[Anonymous · Accepted solution]

Are you using Talend Open Studio or enterprise subscription product? If the former, it is impossible to do it. If the latter, you are able to define a dynamic schema, and get the schema metadata and parse it.

Regards
Shong

[Anonymous]

Thank you very much Shong. I was able to do this using the tjavarow component and then using getColumnMetadata() and getName()  functions.

---