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.
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