Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #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
20 - Arcturus
20 - Arcturus

Quite interesting one.

Spoiler
0622-challenge_273.PNG
Luke_C
17 - Castor
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
7 - Meteor

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
7 - Meteor

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