Using MultiField Tool to NULL certain columns based on a certain condition

Question

daystoclosestoreiddealnumber221234ABC1232401245ABC124101122AAB1122111123ABB113

I don't know if this is possible but I am trying to NULL out rows over a number of columns (def more than the 2 shown here), therefore I was wondering if this is possible to do in the MultiField Formula Tool.

I want to apply a condition in the expression as in: If [daystoclose] > 100 then (make [CurrentField] = NULL) else (keep value in [CurrentField]) end if.

So the final result would look like this:

daystoclosestoreiddealnumber221234ABC123240[NULL][NULL]101122AAB112211[NULL][NULL]

Thank you for everyone's help and feedback!

BrandonB · Accepted Answer

Hi @whitkrieng

This formula will work for you:

IF ToNumber([daystoclose])>100
THEN Null()
ELSE [_CurrentField_]
ENDIF

Just make sure that you have daystoclose UNCHECKED in the configuration, you have it set to "All Types of" fields, and you have "Copy Output Fields and Add" UNCHECKED.  Example screenshot below.

Emmanuel_G · Accepted Answer

@whitkrieng ,

One way to do this