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

JLdG
6 - Meteoroid

Interesting looking through answers from others. I followed the assumption we want all the date up to today, using the transpose tool to identify earliest and latest date for each client number never crossed my mind! 

 

Spoiler
JLdG_0-1624346703926.png

 

NiallJ
7 - Meteor

First time responding. Probably more efficient methods but it works.

 

 

Qiu
17 - Castor

Quite interesting one.

Spoiler
0622-challenge_273.PNG
Luke_C
14 - Magnetar
Spoiler
Luke_C_0-1624372417148.png

 

Sashikumar
8 - Asteroid

My Solution.

Spoiler
ch279.PNG
cwkoops
8 - Asteroid

Several ways to do this one.  Generate rows provides a dynamic way to deal with the problem.  

jhaines
6 - Meteoroid

Good thing Alteryx doesn't charge me per tool on the canvas. It works so I'm sending it!

 

Spoiler

jhaines_0-1624381372451.png

 

cAral
6 - Meteoroid

Trying for as few tools as possible

 

Spoiler
cAral_0-1624382320450.png

 

 

 

youngk313
8 - Asteroid

Went a different route than others. Used a crosstab and transpose combination to find the null values and replace them with zeros.

 

Spoiler
youngk313_0-1624404102612.png

 

ngaskill1
7 - Meteor

Been a while since I submitted--I've been using these as a training tool for my team!

Spoiler
ngaskill1_0-1624393307288.png