check if a value exits in another table

[m4u]

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

[swuehl]

This sounds similar to what have been achieved here:

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

I hope this is of any help,

Stefan

[alexpanjhc]

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)