Join Tables and set Flag for New data

[Sai33]

Hello Everyone,

Hope you all are doing good in this crisis times.

I have a tricky situation to deal with. My data looks like the following two tables

Table1:

1

2

3

4

Table2:

1

2

3

4

5

Expected Table:

5

I would only like to have the Rows from Table 2 that aren't present in Table 1 and store in a new Table 3.

Hope my question is clear.

Thanks

Sai

[m_woolf · Accepted solution]

If your tables contain a key field, you could do something like:
Table1
load
     *
from Table1;

Table2:
noconcatenate
load
    *
from Table2 where not exists(KeyField);