How to get the schema from an Excel file

[MaxIT]

I'm now testing to load of an Excel file with more than 30 columns.

Is there any way to get the schema automatically without having to add and rename every single column? thanks

[Anonymous · Accepted solution]

Hi
If the file contains column name, create a Excel file metadata and retrieve the column name automatically under Metadata node in Repository. Refer to this documentation.
https://help.talend.com/reader/TQ2GKCAZ5tvBI38XVYT1ZA/2jqKsz4wl9XOb0xiRVYvgA

Regards
Shong