I want to replace all the cells that contain “null” to “unspecified” in my table. I followed an instructional video in creating a new column in query editor and replace “null” with “unspecified”, but the new column still has “null”. I used the query below:
if 'Incidents' [Province] = null then "Unspecified" else 'Incidents' [Province]
I don’t know what I’m missing here. Can anyone help?