Synchronize the tMap configuration once Excel file is modified

[Anonymous]

Hi all,
I have an Excel(tInputExcel) file and a table(tOracleOutput) mapped using a tMap component. This is just a one-to-one mapping from the Excel file to a target table.
But, my source Excel file's column names are slightly modified by a third party and I always have to do the same change manually in my
tMap component. For example if the Excel file's column name is modified, I have to do the same modification in my tMap's corresponding column.
Is there any possible way to synchronize this without an extra effort?

[Anonymous]

Hi,
Have you set Mapping links display as "Auto" in tMap component.


Best regards
Sabrina

[Anonymous]

Hi,
If your input metadata for excel file is changed, then job will throw the error at the input itself. tMap is the component which inherits the metadata from input. If the input column name changes, then you will have to again map it to output in tMap.
There is no escape for changing metadata in TOS...
If the order of the column is not changing, then there is an alternative... use default column names given by talend as Column0 etc and then use same in tMap as well from input side. Use whatever columns in the output as per your need. In this case, don't use header, skip the header while creating metadata.
Vaibhav

[Anonymous]

hi all,
very tricky solution  sanvaibhav , but you have not way to be sure that right data goes in the right column if position also change.
But as you said without dynamic schema (out of TOS) no esay way ! 

regards
laurent

[Anonymous]

Hi asthiwanka,
Is there any update for your issue?
Best regards
Sabrina