rename column when reading excel files

[Vincentsoy]

Hi everyone,
I’m trying to read multiple excel files into knime with a loop in order to create a big table at the end with all the excel files gathered together. The Problem is, that the last two columns of every file have a different name so KNIME doesn’t recognize them as matching columns. Is there a way to rename columns before they are being read and ad it to my workflow so that the Table row to Variable loop start works properly?

For better understanding:

[izaychik63]

See if on Excel Reader Advanced Setting tab checkmark Support changing file schemas will help you.

[Vincentsoy]

Unfortunately not working, the node also took nearly 30 min. to execute

[mlauber71]

@Vincentsoy

Is there a way to rename columns before they are being read and ad it to my workflow so that the Table row to Variable loop start works properly?

@Vincentsoy would you know which files would contain these column names that have to be changed or can you create a table which name would have to be turned into which other name?