Generating values to Blank or Null values in a field/column

[Anonymous]

I have a field/column called LeaveCode with different values eg(AA, PH, AS) along with blank or null values.

How do I populate or generate values for these blank values so that it can be renamed as WD?

[YoussefBelloum · Accepted solution]

Hi,

try this on the script:

if(len(trim(LeaveCode))=0,1, LeaveCode) as LeaveCode  ==> this insert the value 1 when it is blank or null

you can put whatever you want instead of 1

[Anonymous]

Thank you!

[YoussefBelloum]

you're welcome, good luck