I have an issue with Joiner node
I have two tables to be joined:
- Common columns: User name- Business unit- Country- Week-Month- and Year
Table 1- column B
Table 2- column NB
So I used joiner, using as matching rows the common columns to get for the same user all the information in the same row, but I have this instead:
Here the configuration of my node
I tried with other tables and works properly, but here no, and I am getting crazy finding the error
Thanks in advance
Hi @Mariaper , what is it that you are saying is wrong with the output? Without knowing the input data, I cannot say whether the result is right or not. Can you describe what you expect the result to be?
You have asked for return of both Matched and Unmatched rows and these are not split on different ports, which explains why you may end up with missing values on some rows. Is that the problem?
This is My A table
This my B table
This is what I get
And this is my expected result
The information fo the same week- month and year should be in the same line, not in different lines
So, in table A I have the common columns and the B hours column
In the column B I have the common columns and the NB hours column
And I want a table with the common columns, the B hours column and the NB hours column with the information for the same user- week-month-year in the same row
Hi @Mariaper , from your first post, I think you are also joining on Business unit too. But in these tables Business unit is missing, so I think it won’t match
missing = missing
To check if that is the issue, you could try using a Missing Value node on the Business unit column on both tables prior to the join, and set it to some other value (e.g. “unknown” or “n/a”), and then the join should work.
Hi Takbb! Yep I added N/A for all the missing values (Business unit and country) and now is working! Thank you for the advice!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.