NULLASVALUE function not working on fields that contain Null values in QVD files?

[jblomqvist]

Hello,

Has anyone noticed NULLASVALUE function not working on fields that contain Null values in QVD files?

E.g. If I have data loaded from QVD files and some fields have null values, the NULLASVALUE does not assign a replacement.

It works on other types of data sources.

[swuehl]

Have you tried with an unoptimized QVD LOAD (e.g. using ...WHERE 1=1)?

[nizamsha]

Hi

As my understanding is correct that u r telling null function is not working in QVD .have u checked in this manner

if(isnull(Urfield)=-1,'Null',urField) as Field

if its not working

if(trim(len(urfield))>=1,urfield,'Null')

anyone will work in your scenario