[beginners] transform table to other table

[al_pasq]

Hi,
I’m totally noob in data, I use knime for my personnal pleasure, so I 'm sorry if my question is stupid.
I want to transform and merge a big existing table (xlsx) to another existing table (xlsx). But column name are different. I make a this

Orange arrows need conditionnal data transformation. but later.

I search with JOIN, CONCATENATE… the data in table 1 must be found in the columns in table 2. Is there a visual way of doing this ? Or do you have to rename each column before merging?
thank a lot

[knimediger]

@al_pasq

First of all: Welcome to the world of KNIME.

Looking at your question: It is necessary (and possible) to rename the columns. Maybe you have a look at this thread Renaming of lot of columns

[hmfa]

Hi @al_pasq.
When you inport your xlsx file with an excel reader node, at the transformation tab, you can identify the column names and data type for your fields and geave the same names and types you need.

Br