Load Script

[#1]

I have seperate tables for Expenses, Budgets, Account Number and Cost Center Number. The Expense table and Budget table has fields for Account Number and Cost Center. These are excel files. The Account Number and Cost Center excel file has ALL possible numbers available (whether or not there is Expense or Budget activity). When I load the Account Number and Cost Center tables into QlikView I only want to load numbers that match either the Expense file or the Budget file.

How should the script look.

Thanks,

Stephen

[#2]

Take a look in the QV documentation at the KEEP statement. If you use a LEFT or RIGHT join with KEEP it will load a second (or third, etc.) table but only those rows that "match".

[Oleg_Troyansky]

The best way is to use function exists():

load

...

where exists(AccountNumber)

;

Notably, exists() is the only form of "where" selection that keeps QVD loads as optimized, and from this perspective it's even better than simple "Where A=B".

regards,

Oleg