Add a "0" in column A if Column B say #N/A

[TomP]

Hi everyone,

New to Alteryx, so hopefully is a simple question for you :).

I would like to add a "0" at the end of each cell in column A, only if in column B it says "#N/A".

Column A contain alphanumeric values and is formatted as text.

Thanks! 

[MarqueeCrew · Accepted solution]

@TomP,

IF [Field B] = "#N/A" THEN [Field A] + "0"
ELSE [Field A]
ENDIF

or...

IIF([Field B] = "#N/A",[Field A] + "0",[Field A])

You would use a formula and update the variable 'Field A'.  Note:  If that field is not long enough to house the biggest value plus a ZERO then you need to use a SELECT prior to the formula and increase the size of the field.

Cheers,

Mark

[TomP]

Hi Mark,

Thanks so much!

Tom