I would like a slightly different of
Set Operator (Complement) that would return not only difference keys but also the corresponding rows in the first file.
Here is an example. Suppose I have files
File2 that both contain a column, say
Key, in a way that the difference of these columns is nonempty.
I would like to retain the rows in
File1 whose Key lies in the difference of
File2 according to
Key. In this case, a
Set Operator (Complement) node generates
Ultimately I want to retain the rows in
File1 whose key lies in the complement, i.e.
One way that I thought about it is, as above, to generate the complement and then use it as a kind of dictionary, but I do not know how to retain the rows in
File1 whose key appears in this dictionary. There may be another way.
Any help will be appreciated!