topic Search Field in QlikView

Search Field

Thu, 05 Sep 2013 09:20:59 GMT

I have a Field with the values 1 and 2. They are for the DB1 and DB2. These two DB should be the same.

Now I would like to filter them. It should show me all values whiche are in DB2 and not in DB1.

Thu, 05 Sep 2013 09:25:44 GMT

Hi,

While loading your data you can use where not exists () function in your load statement.Hope this will help

Load *,

DB As DB1

From My_table;

Load *,

DB As DB2

From My_table1

Where not exists(DB,DB1)