Node created an empty data table.

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.

1 Like