I am trying to join two tables from database readers. There has been some manipulation but both tables come from the same excel source. When I try to join I get an empty table. Through searching the forum I found the strip() manipulation but that has not helped.
I have attached a screen shot
Hello @pgh_mark
The Join-Node lets you choose the columns over which the join should be performed. Dependent on the join operation (default is “inner join”) the rows will be combined.
I assume you join over Row-ID and use the “inner join” option. This means that the node only combines rows with identical Row-IDs. If your two input tables have different Row-IDs you will get an empty output table.
A solution would be to append a new column with IDs in both input tables and then join over the ID columns.