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

Spalders
8 - Asteroid
Spoiler
Spalders_0-1624297537605.png

 

MatthewBr
Alteryx
Alteryx

Nice challenge - Never used Generate Rows before now. 

CandiceDB
Alteryx
Alteryx

My solution:

 

Spoiler
CandiceDB_0-1624306310433.png

 

TonyA
Alteryx
Alteryx

This one is more of a "stream of consciousness" workflow. I didn't plan it out, just started throwing tools on the canvas. Certainly not the recommended way of building out a workflow 🙂. I'm sure it could be tightened up quite a bit.

Spoiler
TonyA_0-1624307349945.png

 

JeffF
Alteryx
Alteryx
Spoiler
JeffF_0-1624311396790.png

 

AkimasaKajitani
14 - Magnetar

My solution.

 

Spoiler
AkimasaKajitani_0-1624321672482.png
kelly_gilbert
12 - Quasar

My solution is pretty similar to many others:

 

Spoiler
kelly_gilbert_1-1624327838047.png

 

Since this was a pretty quick one, I decided to experiment with some slightly different configurations, to see if there were performance differences:

Spoiler
I wondered how big of a performance hit I was taking, since I opted for the convenience of the Data Cleansing tool. I tried replacing it with a Formula tool to replace the nulls with zeroes.
kelly_gilbert_1-1624326155294.png

 

Next, I tried moving the Formula tool (to fill in the zeroes for the missing records) to the left output of the join only.
kelly_gilbert_2-1624326279189.png

Results:

Spoiler
I randomly generated a larger test dataset with 2,600 unique client IDs and 636K input records (with the workflow adding 300K records to fill in the blanks), and then ran each configuration 30 times on the same dataset.

Even at that much larger dataset size, the workflow ran in < 5 sec, and Data Cleansing tool added less than 1 sec to the average run time. I was expecting a larger difference. It would be interesting to see how that plays out with an even larger dataset.

Moving the formula tool didn't make a measurable difference in run time, although the measurement isn't very precise.


kelly_gilbert_0-1624326692591.png

 

DaisukeTsuchiya
12 - Quasar
Spoiler
キャプチャ.JPG

kelvinlaw
8 - Asteroid

Here is my solution:

Spoiler
kelvinlaw_0-1624329951914.png

 

mike_w
8 - Asteroid

don't take this as an excuse to do any non-essential online shopping! 

Spoiler
mike_w_0-1624332764776.png