Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using where not exist

Hi There,

How to find the differences in a column (similar) between 2 tables.

Example: There are 2 tables (Fact1 and Fact2), each containing a common field called "ID". I want to find out which values do not exist in Fact2.

Desired Result - "B" and "C"

I Where not exists.png

Thanks,

1 Solution

Accepted Solutions
MarcoWedel

see your other thread regarding this topic:

List difference / delta between 2 columns in 2 different tables in load script

hope this helps

regards

Marco

View solution in original post

1 Reply
MarcoWedel

see your other thread regarding this topic:

List difference / delta between 2 columns in 2 different tables in load script

hope this helps

regards

Marco