Load Fields where a Field is empty (has no value)

sammo — Sat, 16 Nov 2024 19:10:33 GMT

Hello Community

I have a question about loading a qvd-File like this:

Load
ID,
Name,
Surname,
Birthdate,
Address,
City
FROM Adresses.qvd
WHERE Birthdate > then date('01.01.1950', 'dd.mm.yyyy') OR Birthdate = '';

So i want to load all de rows where the birthdate is higher than 1950 and all the rows which have an empty birthdate-field.

the bigger than works fine, but the rows with the empty birthdates are not in the resulting dataset.

any ideas?

thank you very much!

Re: Load Fields where a Field is empty (has no value)

Anil_Babu_Samineni — Wed, 05 Feb 2020 13:21:02 GMT

If your date format is the valid, U can try

Load
ID,
Name,
Surname,
Birthdate,
Address,
City
FROM Adresses.qvd
WHERE Year(Birthdate) > 1950 or IsNull(Birthdate);