Keep different element of two columns

[sdevita7]

Hi!

I am trying to compare the values contained in two different tables, let’s say:

TABLE 1

TABLE 2

I would like to create a TABLE 3 containing the values that are in TABLE 1 but not in TABLE 2 (in this case B, F, H, and G).

Any idea?

Thanks in advance

Simona

[HansS]

Hi @sdevita7

Take a look a the Reference Row Filte node.
gr. Hans

[sdevita7]

I am trying to use it, but it takes only one input and I have two tables. I tried to join them but it seems it is not working

[HansS]

Hi @sdevita7

The Reference Row Filter takes two inputs . See this wf reference_row_filter.knwf (14.4 KB)

Or am I missing something?
gr. Hans

[sdevita7]

I am so sorry, I confused this with the Rule-based row filter.

Thanks a lot!

[morpheus]

Hi @sdevita7,

Hans suggested the ‘Reference Row Filter’ Node not the ‘Rule-based Row Filter’ - Node!. If you use the Node which Hans suggested you get the solution and it is not a big deal.

BR
Hermann