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 updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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
6 - Meteoroid

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

 

 

Qiu
17 - Castor

Quite interesting one.

Spoiler
0622-challenge_273.PNG
Luke_C
13 - Pulsar
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