Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Is it fields/columns or is it values you want to compare?
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.
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
Awesome...Thank you i will give this a try