How to fill null values within a dataset with text

Question

Hi all,

I have four null values in the "Series" field of a large dataset. I am wondering: how can I fill in these null values with text (what tool do I need)?

Specifically, the text values I want to input in the "Series" field are N2, Ro2, P2, and V2.

Please help me if you can.

MichalM · Answer

@Jack5

This will very much depend on the logic you would like to apply. How would you decide where each of those values will be inserted? Is there a value in another field you can use as a reference? ie If the value in the Series column is null and value in column B is X then I would like Series to be "N2".

If that's the case, you could use a conditional statement in the Formula module

IF IsNull([Seiries]) AND [B]="X" THEN "N2"
ELSEIF IsNull([Seiries]) AND [B]="Y" THEN "Ro2"
ELSE [Seiries]
ENDIF