How to capture column name changes automatically in Talend from Input Excel

[Anonymous]

Hi Team,

I am trying to develop a job that will load data from an excel and I am using tfileinputexcel component to load the excel.

The field names of excel will change in future and I need the job to capture those field name changes automatically.

As I understand, Built in and Repository schema options will not work for this requirement . I am using Talend Open studio.

Please direct me to design a job to capture the column name changes in Talend job automatically.,

Thanks & Regards

Shalu

[Anonymous]

Hi Shalu,

     The best way will be to use Dynamic schema for ingestion but it is limited to Enterprise version of Talend. If you have to change the column names for an existing file, you will have to refresh the repository and associated Talend jobs manually.

https://www.talend.com/blog/2019/10/31/magically-shuffle-columns-talend-dynamic-schema/

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Anonymous]

Thank you, Nikhil for the response. 

Manual refresh will not work for me because I need to schedule the job from Centos by taking the job build.

[Anonymous]

Hi,

   In that case, the recommendation would be to upgrade your Talend to Enterprise version so that you can utilize Dynamic schema.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved