Hi,
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.
2 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.