join tables with unequal row numbers

I have 2 tables, one with 8 number of rows (row IDs 1,2,3,4,5,6,7,8) and another with 7 number of rows (row IDs 1,2,3,5,6,7,8). I want to know how to join the two tables and have values written out in front of the right row IDs for each.

Hi @ruchirav

You can use a Joiner node for this with the columns set to Row ID on both sides. Depending if you want to retain the non-matched records you can go for an inner or left/right outer join.


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