topic Re: Compare 2 fields in separate tables in QlikView

Compare 2 fields in separate tables

tsoley9262 — Thu, 30 Jan 2020 15:58:21 GMT

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

Re: Compare 2 fields in separate tables

petter — Thu, 30 Jan 2020 16:29:08 GMT

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

Re: Compare 2 fields in separate tables

tsoley9262 — Thu, 30 Jan 2020 17:26:46 GMT

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.

Re: Compare 2 fields in separate tables

petter — Thu, 30 Jan 2020 17:36:52 GMT

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

Re: Compare 2 fields in separate tables

tsoley9262 — Thu, 30 Jan 2020 17:59:17 GMT

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