Join Tables and set Flag for New data

Sai33 — Sat, 16 Nov 2024 00:53:13 GMT

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:

Table2:

Expected Table:

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

Re: Join Tables and set Flag for New data

m_woolf — Tue, 07 Apr 2020 13:45:55 GMT

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);