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
1 Like
That worked, thanks!
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.