Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolved:)
Done
Below my solution
Just a simple formula will do the work here. Adding workflow would not be required as below formula explains it all
IF IsNull([Address]) THEN ToString([Apt/Unit])+","+[Zip] ELSEIF IsNull([Apt/Unit]) THEN [Address]+","+[Zip] ELSEIf IsNull([Zip]) THEN [Address]+","+ToString([Apt/Unit]) ELSE [Address]+","+ToString([Apt/Unit])+","+[Zip] ENDIF
Use select tool to just selsct the one colum for the desired output
my solution. I wish Alteryx had Coalesce function :)
what's that yellow tool you used? It looks like comparison tool of two outputs & where to get one ?