topic Re: Get column names of Excel file in variable (Dynamic Schema for Excel) in Talend Studio

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

Anonymous — Tue, 18 Feb 2020 15:46:24 GMT

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.

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

Anonymous — Thu, 20 Feb 2020 04:48:09 GMT

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

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

Anonymous — Thu, 20 Feb 2020 06:43:30 GMT

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