Joiner isn't returning elements from a new table

I’ve joined together multiple tables but the data from one table isn’t being included and I can’t figure out why. It’s the third join in this workflow and the dateID (integers) apparently isn’t matching the RowID (also integers).
KNIME_project.knwf (80.2 KB)

I don’t know how to edit, but that project link probably isn’t correct. Use https://hub.knime.com/bart_humphries/spaces/Public/~Shtxqks0xMUps6un/

You can make it work if you select String Representation rather than value and type as comparison method:

Not 100% sure, but when you inspect your right table you will notice that the RowID column is actually not showing a specific data type like integer:

Therefore treating everything as string seems to be a reasonable solution :slight_smile:

1 Like

That worked, thanks!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.