Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multifield Formula tool not outputting correct values from NULL values.

csh8428
11 - Bolide

The selected VW_String fields can have 3 values: Y, N, and NULL. I want to change NULL to "NA". I configured the multifield field formula tool as in the screenshot, but after that tool there are no "NA" values and it looks like it's actually turning the NULLS to "N"s.

 screenshot.png

1 REPLY 1
csh8428
11 - Bolide

I figured it out. The value size of those columns was 1. I set it to 2 and it worked fine.

Labels