using "Between" and "is not null" in load editor from a QVD

[assadandre]

Good Day,

Can anyone advise if there is any way to use "Between" and "is not null" functions in the load editor when loading data from a QVD?

and if yes, how?

Thanking you in advance.

Best regards,

[mhaferkamp]

Hi Assadandre,

If you need a function like between in the where statement use the following syntax:

Load
    FieldA,
    FieldB,
    -------
From ----------------
where Date >= makedate(2019, 1, 1) and Date <= today();

Please make sure that your date in your dataset doesn't contain a timestamp. This could help you: Date and time functions

In my opinion the best solution to find empty or filled cells is the following where statement. You can combine it with the where statement before (AND operation).

where len(trim(FiledName)) > 0;

I hope I was able to help you. Best regards,

Marius.

[Marcos_rv]

LOAD

...

...

...

FROM ...

where not isnull(ALGO);