Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #366: Three Columns Are a Crowd

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
W366.jpg
JitendraPal
7 - Meteor

Solved:)

Mohan0009
5 - Atom

Done 

FrederikE
13 - Pulsar
Spoiler
FrederikE_0-1681222385815.png

 

messi007
15 - Aurora
15 - Aurora

 Below my solution

Spoiler
messi007_0-1681226894700.png

 

Aarshay
5 - Atom

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
7 - Meteor

my solution. I wish Alteryx had Coalesce function :)

Spoiler
opoleleyeva_0-1681230282309.png

 

Arjunmarwaha09
8 - Asteroid

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

ed_hayter
12 - Quasar
Spoiler
ed_hayter_0-1681233253803.png

 

amruthas1287
6 - Meteoroid

My solution