ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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 #190: Supply Chain Management Challenge

MattBenj
Boule de feu

Saw the challenge title and I had to hope on this one quick. Solution attached.

mbogusz
Comète

Weird that the Negotiation file contains hard-coded [Null]'s in it. It seems a bit superfluous. And annoying too to have doubles and strings in the same data column.

 

Révélation
2019-11-21 19_36_31-Greenshot.png
Inactive User
Non applicable

Here you go the solution!!!

 

 

Best Regards,

SP

 

 

cdavis19
Météore
Révélation
cdavis19_0-1574428134082.png
etzele
Astéroïde

My solution

GHM
Atome

More practice with pivoting tools, which I need. 

Reesetrain2
9 - Comet
9 - Comet

All,

 

Révélation
I used some different methods than some others, mostly using three joins and 3 unions to go along with Transpose and CrossTab to generate the concatenation. Cheers!
Matt

Capture.PNG

kelsey_kincaid
12 - Quasar
12 - Quasar
Révélation
Challenge190-KA.PNG

SeanAdams
17 - Castor
17 - Castor

Solution attached below:

 

Révélation

SolutionImg.png
BradWerner
Bolide
Révélation
190_Capture.png