topic check if a value exits in another table in QlikView

check if a value exits in another table

m4u — Thu, 01 Dec 2011 15:38:17 GMT

hi all,

I have 2 tables of credit card transactions, one is our internal billing table, and the other table comes from the credit card company.

I want to compare those 2 tables, and find out the records that exists only in one of the tables.\

here is the tables structure:

BillingTable:

BillingReference,

BillingAmount

ComparedTable:

ComparedRference,

ComparedAmount

I want to show a pivot of all records in the billing table, who doesn't exists in the ComparedTable (according to Reference field), and another pivot with records that exists only in the ComparedTable.

how could i do that in qlikview.

thanks for any help.

shlomo

check if a value exits in another table

swuehl — Thu, 01 Dec 2011 15:53:11 GMT

This sounds similar to what have been achieved here:

http://community.qlik.com/message/138549

I hope this is of any help,

Stefan

Re: check if a value exits in another table

alexpanjhc — Tue, 14 Aug 2012 21:14:07 GMT

can you in your load script do something like

exists and not exists

to do what you want to do?

example

ComparedTable:

load

ComparedRference,

ComparedAmount

from ComparedTable

billingTable:

load

BillingReference,

BillingAmount

from BillingTable

where exists (ComparedRference,

BillingReference)