JOIN FIVE EXCEL

Good morning!

How can I join five excels imported with 5 different excel reader components?

Thank you in advance!!!

Hello @helfortuny,

if by join you mean concatenate/union then you can use Concatenate node or try to read all Excel files with single Excel Reader using Files in folder option if they are in same (parent) folder. If by join you mean matching based on one or more columns then you need Joiner node.

And it’s far from morning where I am :wink:

Br,
Ivan

1 Like

I mean join the data and arrange them into multiple columns. So it’ll be de joiner. I know hwo to do it with 2 tables coming from different files, but how can I join five tables?

Thank you!!!

Hello @helfortuny,

with multiple, cascading, Joiner nodes. If you have only one matching column and unique values you can use Cell Replacer node. I prefer it as it’s more intuitive in such cases and easier to configure.

Br,
Ivan

2 Likes