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 deal as below
IF(IsNull(YourFieldName) or len(trim(YourFieldName))=0,'Unknown', YourFieldName) as YourFieldName
Try an if statement:
if(len(trim(fieldC))=0, 'MyValue', fieldC) as fieldC
you can try like
then it will mark null as value only in this field,
if you use
nullasvalue * mean all fiels,
only in these two fields...
see in the help file...
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.
You can check the following video post on my blog:
I hope this helps!
Retrieving data ...