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 #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
17 - Castor

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