When you want to join tables you need to specify the joining columns. That means when there are rows where the values in those joining columns are the same then the rest of the columns from both tables will be joined together.
Now look at your tables and let me know which records of the three tables should be joined together?
It seems you can only join the first two tables based on “Id” and “User” columns if they refer to the same person.
You have “Sales” column in all three tables but are they all refer to the same thing? The sales by a person and the sales of a product. They are not the same. And if they were the same still they need to be unique or you get several redundant records from both tables joined together.
Here is a case where you can use joiner:
Suppose we have a table of book details. And another table has the information about our authors:
Book table:
Author table:
Now we want to have all the author information along with book details. We use a joiner and the “Author ID” column in both tables as the joining column. The name of the column could be different but it’s they role which is important and in this case both “Author ID” columns refer to the same person.
It’s good idea to use the concatenate node, but how it work with a loop. My purpose is to use a list of excel files, read all of them and then concatenate in a single table or a file.