We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #273: Filling In The Blanks

Emil_Kos
16 - Nebula

Hi,

That was fun

 

Emil_Kos_0-1624664306915.png

 

johnzrgu75
7 - Meteor
Spoiler
johnzrgu75_0-1624751484492.png

 

nlensing001
7 - Meteor

My solution

Spoiler
challenge_273_start_file_Nick Lensing.png
amir_alteryx_2021
6 - Meteoroid
Spoiler
Capture.PNG
RichoBsJ
10 - Fireball

Hi! Here my solution 🙂

Maskell_Rascal
13 - Pulsar

I loved seeing everyone's approach to solving this problem, and also kick myself for not thinking of using the generate rows tool! Even when submitting the challenge, I learn something new. 🤓

 

The solution provided was one of two different ways we had originally come up with building the workflow. Below is the second approach which utilizes an Advanced Join macro that is available on the gallery. 

 

Spoiler
Maskell_Rascal_0-1624889168979.png

 

Cheers!

Phil

AngelosPachis
15 - Aurora

My solution to challenge 273 

 

Spoiler
AngelosPachis_0-1624891990666.png

 

KaneG
Alteryx
Alteryx

I love the chance to use a join as a filter...

 

 

Spoiler
Redundant Select tools, but I like having them separate to the Join
KaneG_0-1624933638892.png

 

 

 

YoshiroFujimori
7 - Meteor

I like Cross Tab and Transpose.

Spoiler
YoshiroFujimori_0-1624962632750.png

 

jpowellsd
Alteryx
Alteryx

Good practice with generate rows

Spoiler
jpowellsd_0-1625006716815.png