topic Re: LOAD RESIDENT | WHERE = MULTIPLE VALUES in QlikView

LOAD RESIDENT | WHERE = MULTIPLE VALUES

nico_ilog — Thu, 16 Oct 2014 14:15:05 GMT

Hey Guys,

I need some help!

Maybe i'm just being a NOOB! But i need to know if there is a possibility to do a Resident load, specifying MULTIPLE parameter field values for the one specified field?

Resident SalesDetails

WHERE left(SH_CashSlipId,1) = 'C' OR 'D';

Drop Table SalesDetails;

How does this work?

Because this:

Resident SalesDetails

WHERE left(SH_CashSlipId,1) = 'C';

Drop Table SalesDetails;

Works fine?

Thanks in advance?

Re: LOAD RESIDENT | WHERE = MULTIPLE VALUES

alexandros17 — Thu, 16 Oct 2014 14:17:30 GMT

the sysntax is:

WHERE left(SH_CashSlipId,1) = 'C' OR left(SH_CashSlipId,1) = 'D';

or you can use

Where Wildmatch( left(SH_CashSlipId,1) ,'C','D')>0

Re: LOAD RESIDENT | WHERE = MULTIPLE VALUES

maternmi — Thu, 16 Oct 2014 14:17:39 GMT

Hi,

try this

WHERE

left(SH_CashSlipId,1) = 'C' OR left(SH_CashSlipId,1) 'D';

Drop Table SalesDetails;

Michael

Re: LOAD RESIDENT | WHERE = MULTIPLE VALUES

nico_ilog — Thu, 16 Oct 2014 14:22:04 GMT

Thanks brother! Worked!