Replace null value with the value in the next column

Question

I am trying to replace the null values in the column "Extracted_Telstra_Site_ID" with the values in the next column "Extracted_Telstra_Site_ID_2", please see the image attached.

Capture.PNG

ShankerV · Accepted Answer

Hi @arsalanzaki

Step 1: Formula tool

IF IsNull([Extracted_Telstra_site_ID])
THEN [Extracted_Telstra_site_ID_2]
ELSE [Extracted_Telstra_site_ID]
ENDIF

Many thanks

Shanker V