SQL Select Statement for Empty Data

Fri, 17 Jul 2009 00:17:50 GMT

Hey, so I am trying to load data but only the ones with the following two criterias:

1. The enddate needs to be greater then today's date or
2. If enddate is empty then load the data

LOAD uname as Username,
FROM  (ooxml, embedded labels, table is [test])
WHERE not(date(enddate,'MM/YYYY') < date(today(), 'MM/YYYY')) or enddate = "";

I put the following code into qlikview and I get an error saying Field not found - <>. Does anyone know what I am doing wrong in the code?

SQL Select Statement for Empty Data

disqr_rm — Fri, 17 Jul 2009 01:32:18 GMT

Try with enddate = ' ' --> Single quotes. And make sure enddate field is in your XLS file.

I think you can rewite the whole WHERE line as:

WHERE enddate GE today() or len(enddate)=0;

If nothing works, just post here a sample XLS file.

topic SQL Select Statement for Empty Data in QlikView

SQL Select Statement for Empty Data

SQL Select Statement for Empty Data