Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #190: Supply Chain Management Challenge

Highlighted
Fireball

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
Spoiler
Annotation 2019-11-18 110923.jpg
Highlighted
Magnetar
Magnetar

My solution!

 

Spoiler
WeeklyChallenge190.JPG

Cheers!

NJ 

Highlighted
Alteryx Partner

Happy Monday! 

 

Spoiler
190BH.jpg
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Spoiler
18-11-_2019_17-33-31.png
Highlighted
Alteryx 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 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
Meteor

here is my solution

 

Spoiler
PaulFound_0-1574101284660.png