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

Ellie_Parker
8 - Asteroid

Challenge completed😀

shawnmacnova21
5 - Atom

Nice to work with a new tool! I don't get to use Generate Row much

 

Spoiler
shawnmacnova21_0-1625066234645.png

 

jagdeep_singh85
8 - Asteroid

PFA my solution

ncrlelia
11 - Bolide

Challenge 273

vikb03
8 - Asteroid

Took an alternative path to the solution!

 

Spoiler
Not as dynamic but wanted to practice with the multi-row tool!

vikb03_0-1625482958994.png

 

 

mbogusz
9 - Comet
Spoiler
Weekly Challenge #273 in the canWeekly Challenge #273 in the can
OllieClarke
13 - Pulsar
13 - Pulsar

Catching up after a break

Spoiler
OllieClarke_0-1625651658906.png

 

dhavaldoshi
8 - Asteroid

How to do it as a Beginner?

  • Creation of master data: Generate Rows and Right Outer Joins - could be a very useful tip working for KPIs if incase you are trying to account for 0s
  • Null vs 0s: This problem statement requires us to impede 0s, however remember there's a difference between 0 and a null
    Spoiler
    Solution_273.png
Elias_Nordlinder
11 - Bolide

My solution:

Spoiler
Elias_Nordlinder_0-1626251237497.png

 

xAJBx
7 - Meteor

Here's mine!