Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking to mark all Null in only one field as a value. I added the NullasValue to my script but it marked all Null as a value. I am only looking to mark only one field Nulls as a value.
you can try like
NullAsValue FieldName;
then it will mark null as value only in this field,
if you use
nullasvalue * mean all fiels,
NullAsValue Field1,Field2
only in these two fields...
see in the help file...
You can deal as below
IF(IsNull(YourFieldName) or len(trim(YourFieldName))=0,'Unknown', YourFieldName) as YourFieldName
Try an if statement:
LOAD
fieldA,
fieldB,
if(len(trim(fieldC))=0, 'MyValue', fieldC) as fieldC
fieldD,
...
FROM ...
you can try like
NullAsValue FieldName;
then it will mark null as value only in this field,
if you use
nullasvalue * mean all fiels,
NullAsValue Field1,Field2
only in these two fields...
see in the help file...
Hi Dan,
You can check the following video post on my blog:
http://qlikshare.com/qlikview-video-tutorial-convert-null-values-selectable-strings-qlikview/
I hope this helps!
Cheers,
DV
Thank you very much, this was the answer i was looking for. I did have * and did not put two and two together. Great job! Thank you again.