How can I join more that two tables?

Node Development
1

Hi!

I have 4 tables (per month) and each one have the column of the name and the columns of the indicator of the month, however in some months there are names that does not appear in other months, so I need that my output table has the name of the person and the indicator of the month for each person, although the person does no appear in all the months.

How can I do that?

2

You could cascade several join nodes

Or you could load the data into a database and use SQL executor.

There is also a new joiner node in labs status that would help further in using various joining scenarios.

2 Likes
3

Hi @LilianaGarcia,

could you please provide a short example.
Maybe concatenate (optional in) node and pivot node does the job.

BR