rename column when reading excel files

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:

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

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

@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?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.