compare two columns and remove non-matching values

Hi all,

I have a column lets say having values A,B,C,E,F,H,I and another column having values A,B,D,E,F,G,H,I
I need to compare these two columns and remove non-mataching values e.g. the output should be common values (intersection) only, which are A,B,E,F,H,I
Thanks in advance


how about using the Joiner Node (maybe after a group by). and join the matching columns back together.

1 Like