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.

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 #291: A Winning Halloween Candy Basket

KaustubhPadwal
5 - Atom

Solved and workflow attached

AndrewS
11 - Bolide

#291

Spoiler
291.PNG
Shifty
12 - Quasar

The solution has several columns with identical names.  Try as I might, I was unable to get Alteryx to do this.  I'm on 2021.4 though so I've told myself it's because of that.

 

Column name frustrations:

Spoiler
For some reason (although my inputs are all labelled correctly), they appear a mess in the embedded select of the Joint Multiple tool (e.g. sugarless candy appearing several times):
Shifty_0-1646398699587.png

The embedded select says Input_#2 has sugarless candy as a field but Input 2 doesn't have that field!:

Shifty_1-1646398766675.png

Attempting to force a change in column names with a Select tool:

Shifty_2-1646398818544.pngShifty_3-1646398824733.png

 

 Anyway, here's my solution:

Spoiler
Shifty_4-1646398867984.png

 

DataNath
14 - Magnetar

My solution to #291.

 

Spoiler
DataNath_0-1646408473789.png

 

KateG
Alteryx
Alteryx

kg solution

Hitch
8 - Asteroid

Here's my attempt

SylwiaDragon
8 - Asteroid

Done

Divya_Bidarahalli
8 - Asteroid

Solved it. 

Mike_Warner
6 - Meteoroid
Spoiler
Mike_Warner_0-1648647949885.png

 

Wish I'd thought of join multiple. Lesson learnt!

NikyN
9 - Comet
Spoiler
NN - Challenge#291.PNG