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!
Solved! Go to Solution.
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
Hi Mark,
Thanks so much!
Tom