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
9 - Comet

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

mbogusz
9 - Comet

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.

 

Spoiler
2019-11-21 19_36_31-Greenshot.png
Inactive User
Not applicable

Here you go the solution!!!

 

 

Best Regards,

SP

 

 

cdavis19
7 - Meteor
Spoiler
cdavis19_0-1574428134082.png
etzele
8 - Asteroid

My solution

GHM
5 - Atom

More practice with pivoting tools, which I need. 

Reesetrain2
9 - Comet

All,

 

Spoiler
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
Spoiler
Challenge190-KA.PNG

SeanAdams
17 - Castor
17 - Castor

Solution attached below:

 

Spoiler

SolutionImg.png
BradWerner
11 - Bolide
Spoiler
190_Capture.png