Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

AYXAcademy
Alteryx
Alteryx

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

 

This week's challenge was submitted by @pawel_zych  - 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

patrick_digan
17 - Castor
17 - Castor
Spoiler
Annotation 2019-11-18 110923.jpg
NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution!

 

Spoiler
WeeklyChallenge190.JPG

Cheers!

NJ 

Blake
12 - Quasar

Happy Monday! 

 

Spoiler
190BH.jpg
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
18-11-_2019_17-33-31.png
Aaron_Harter
11 - Bolide

Great practice concatenating and blending to kick off the week!

Spoiler
190_AH.PNG
JoshuaGostick
11 - Bolide

Fun formatting challenge!

 

Spoiler
challenge_190.PNG
OllieClarke
15 - Aurora
15 - Aurora

I have a feeling it can be done in fewer tools

Spoiler
Challenge 190.png
Sebenius
8 - Asteroid

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

Got it done nothing fancy.

 

Spoiler
Sebenius_0-1574100583841.png
paulfound
11 - Bolide

here is my solution

 

Spoiler
PaulFound_0-1574101284660.png