Consolidate with the same header names

Welcome to the KNIME community!

I am assuming that are you trying to read all of the files in in one go using the same Excel Reader, and in the xlsx files, the table structure is the same, with the same number of columns (and ordering of the columns is the same) in each, but that there are some variations in the spellings of the headings? (If the headings were all the same, it shouldn’t be a problem)

If that is the case, you can do the following:

In the uppermost Excel Reader, you set the config as follows so that no header is set:

In the lower Excel Reader, you set the config to read only one file, which contains the required headers, and tell it to read the headings in row 1, but only read the file from row 1 to 1:

Configure Insert Column Headers as follows:

This should then give you the data from all excel files, using the heading from just one of them.

If this isn’t what you meant, then can you please explain further, and show some examples of what is happening.

1 Like