Where Clause Limitations

[bjsellers57]

I have a very large data set that I built in several QVDs and now in my main application I need to pull data from those QVD's with a pretty extensive where clause.  I am pulling 573 different account in so the where clause to list those Accounts created a 9,368 character line:  (i.e. Where Match([Customer Account], 'Account1', 'Account2', 'Account3', ..., 'Account571', 'Account572','Account_573'))  Please understand these are not the account names as each one is unique, no ways to combine names to make where clause smaller

[maxgro]

you can load the accounts in a table and use a where exists ([Customer Account])

[el_aprendiz111]

Hi Bernard

1-Example:

[SAMPLE]:

LOAD*, KeepChar([Customer Account], '0123456789') as id_Account;

LOAD * Inline

[

Customer Account, Data, Field

Account1, 187, F

Account2, 346, U

Account3, 2286, Z

Account4, 493, A

Account5, 4607, O

Account6, 4906, G

Account7, 1795, O

Account8, 2533, U

Account9, 2959, D

Account10, 2112, P

Account500, 11111, L

Account732, 143, I

Account733, 2412, I

Account734, 1377, P

Account735, 3568, W

Account736, 4190, D

Account750, 3935, G

Account738, 2504, F

Account800, 1238, D

Account801, 4268, I

Account841, 2291, A

];

QUALIFY*;

LOAD * Resident SAMPLE

Where id_Account >= 500 AND id_Account  <= 750;

[bjsellers57]

Thank you very much, I will try this

Bernie Sellers

Analytic Consultant

(p)410.884.2182

(c)240-818-2635