Compare 2 fields in separate tables

[tsoley9262]

I have 2 tables one is static and the second table updates everyday, I am trying to figure out how to show if any new fields show up in the second table that updates every day, I am only comparing 1 field. Only want to show the 'DEF' from the Updated table.

Static Table                                                      Updated table

ABC                                                                              ABC

CBA                                                                              CBA

                                                                                       DEF

[petter]

Is it fields/columns or is it values you want to compare?

[tsoley9262]

I have a column in each table the static one will never change and the other table will decrease as the work is done but possible that a new record could be added, I am trying to find if any new records in the second column show up ....hope this makes sense. 

[petter · Accepted solution]

You have to do something like this:

Static_Table:
LOAD
   *
FROM
  myCSVfile.csv (txt);

Other_Table:
NOCONCATENATE LOAD
  *
FROM
  myOtherCSVfile.csv (txt)
WHERE
  Not(Exists(Field1,Field2));

DROP TABLE Static_Table;

// Field1 is the column/field that belongs to the first table and Field2 is the column/field that belongs to the second table

[tsoley9262]

Awesome...Thank you i will give this a try