Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
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.

Challenge #190: Supply Chain Management Challenge

Highlighted
Alteryx
Alteryx

A solution to last week's challenge has been posted here

 

This week's challenge was submitted by @PawelZych  - thank you for your contribution! 

 

This is a Supply Chain Management challenge. Your task is to generate the Negotiation file for Category Managers that they can use while negotiating new prices with the Suppliers. Match each PN with prior Supplier Names and APV. Create one column that indicates a case where there was more than one Supplier in the historical data.

 

chain_image.jpg

Highlighted
15 - Aurora
15 - Aurora
Spoiler
Annotation 2019-11-18 110923.jpg
Highlighted
14 - Magnetar
14 - Magnetar

My solution!

 

Spoiler
WeeklyChallenge190.JPG

Cheers!

NJ 

Highlighted
Alteryx Certified Partner

Happy Monday! 

 

Spoiler
190BH.jpg
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Spoiler
18-11-_2019_17-33-31.png
Highlighted
Alteryx Certified Partner

Great practice concatenating and blending to kick off the week!

Spoiler
190_AH.PNG
Highlighted
Alteryx Certified Partner

Fun formatting challenge!

 

Spoiler
challenge_190.PNG
Highlighted
Alteryx Certified Partner

I have a feeling it can be done in fewer tools

Spoiler
Challenge 190.png
Highlighted
Alteryx Certified Partner

The text confused me more then help me this time around I think.

Got it done nothing fancy.

 

Spoiler
Sebenius_0-1574100583841.png
Highlighted
7 - Meteor

here is my solution

 

Spoiler
PaulFound_0-1574101284660.png