Challenge #366: Three Columns Are a Crowd

[RolandSchubert]

Spoiler

[JitendraPal]

Solved:)

[Mohan0009]

Done 

[FrederikE]

Spoiler

[messi007]

 Below my solution

Spoiler

[Aarshay]

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

[opoleleyeva]

my solution. I wish Alteryx had Coalesce function :)

Spoiler

[Arjunmarwaha09]

what's that yellow tool you used? It looks like comparison tool of two outputs & where to get one ?

[ed_hayter]

Spoiler

[amruthas1287]

My solution