Qvd filter

[#1]

I am Loading a QVD file.....I have one field which hass null values....I want to load qvd for values whre that field is not null........

ex :-

load

qvd

where field is not null

Please help me how can I give where condition.......

[#2]

I got it...

where len(Field)>0

[Zeta]

Hi,

and for the opposite? Only where the value is NULL?

Thx for help

[Lech_Miszkiewicz]

Hi @Zeta - just use Data Load editor (Instead of Data Manager which is very limited) and put a were clause directly there:

• Where Len(Trim(YourField))=0
• or Isnull(YourField)