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 #64: Catch Me If You Can

Natasha
9 - Comet

For some reason, I couldn't figure out how to configure auto-select, so here is my longish solution. 

Spoiler
Screen Shot 2017-04-03 at 22.51.36.png
MinaGO
7 - Meteor
Spoiler
Screenshot (293).png

Not the most elegant workflow but here is my first challenge solution!
Edit: Removed unnecessary tools :)

 

Simona
7 - Meteor
Spoiler
Picture_challenge_1.PNG
So, first way I thought about was using the transpose and crosstab. Then I thought I did not need to do that and I could have used the dynamic rename straight away, so I did. The dynamic select rule I made is a calc which removes all the fields that do not contain /

First time I participate to these weekly challenges, I will try to be constant from now on. :)

 

I posted 2 solutions, really interesting and useful exercise! Thanks :)

 

 

TaraM
Alteryx Alumni (Retired)

So Fun! Thanks @JoeM.

Spoiler
WC64.png
Tara McCoy
BenMoss
ACE Emeritus
ACE Emeritus

First participation and I love it! 

 

Looks like I need to learn a little more about what the dynamic rename has to offer though ;)

Spoiler
2017-04-08_09-04-33.png
BenMoss
ACE Emeritus
ACE Emeritus

First participation and I love it! 

 

Looks like I need to learn a little more about what the dynamic rename has to offer though ;)

Spoiler
2017-04-08_09-04-33.png
SeanAdams
17 - Castor
17 - Castor

very similar to a few folk ( @toddhowl , @NicoleJohnson etc) - just maybe less tidy

JoeM
Alteryx Alumni (Retired)

The solution has been posted. It appears that @MarqueeCrew and I are identical! 

Coxta45
11 - Bolide

I chose to utilize the union tool's Auto Config by Name & Set Specific Out Order options to tee up my favorite Dynamic Rename method.  Enjoyed this one!

 

Spoiler
Challenge 64Challenge 64
JoshK_dup_167
6 - Meteoroid

Learned something new with the dynamic tools on this one!