Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Have you tried with an unoptimized QVD LOAD (e.g. using ...WHERE 1=1)?
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