Searching for notes to create a reverse filter of customer numbers

Hello,

i have two tables with customer numbers:

e. g.

table 1: all customers with turnover above 1 Mio per year:
customer nr.
1
2

table 2: all customers of system
customer nr.
1
2
3
4
5

As result i need a table which include all costumers, which have a turnover less than 1 MIO

result table should be:
customer nr.
3
4
5

I have only the colums customer nr. in the tables. Which notes can i use to create the result table? Would be great if someone could help me. Thanks regards Chris

Hi,

This is the node you are looking for:

Or

Both of them will do what you want.

Best,
Armin

3 Likes

Hey Armin,

perfect thanks for your fast help . regards Chris

2 Likes

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