Using Exists

[#1]

Hi All,

I am trying to use the following script to load but it won't work:

QUALIFY*;

UNQUALIFY BillingIDCustomerID,

LOAD *, BillingID+' '+CustomerID AS BillingIDCustomerID

FROM

WHERE EXISTS(VisitID)

Basically, I want to only pull records where the VisitID is loaded in QlikView, but when I look at table viewer, the information density on BillingIDCustomerID field is 0. Any ideas? Thanks in advance for your help!

[#2]

Try this:

BillingID&' '&CustomerID AS BillingIDCustomerID

[Oleg_Troyansky]

I believe the problem is caused by Qualify. Because of the qualification, your field VisitID is now called differently (with the qualifier), hence Exists never returns true and nothing is being loaded.

Try unqualifying VisitID.