Combining columns based on position and not headers

[mlauber71]

@jallen23 welcome to the KNIME forum. You can take a look at this example where there is an import using column names A, B, C instead of the headers.

Consolidate with the same header names

Hi @TLKNW , 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: [image] In the uppermost Excel …

You can combine that with loops or try to import all files at once with the Excel reader node. You can also restart a loop after failure.

You can also try and make sure that the files have the same structure and types.

Table Validator

Depending on your data you could also use

Column Auto Type Cast