Data Manipulation

Question

Hi Team ,

Hope you all are doing good !

I stuck in a problem in Alteryx , looking for help "How to assign single value to the multiple columns/variables "

Here in the attached excel sheet, I need to assign Not started wherever is NULL in the alteryx .There are multiple columns/fields,not getting it how to do it in Alteryx

Any method to perform the task. Please

DRAFT.xlsx

Raj · Answer

in your case multi-field formula is the best choice.

ShankerV · Answer

Hi @MB_Rocks

One way of doing this!!!! Based on the input file shared.

Note: If your input data set is having empty cells, then use below. It will work on both null and empty values.

IF IsEmpty([_CurrentField_])
THEN "Not started"
ELSE [_CurrentField_]
ENDIF

Many thanks

Shanker V

Data Manipulation 15022023.yxmd

Christina_H · Answer

You need a multi-field formula tool.  Does the data contain actual nulls, or the string [Null]?  You need one of these formulas, applied to all the fields you want to update:

if isnull([_CurrentField_]) then "Not Started" else [_CurrentField_] endif

if [_CurrentField_]="[Null]" then "Not Started" else [_CurrentField_] endif