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

Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #12: Supply Chain Negotiation

AYXAcademy
Alteryx
Alteryx

Hi Maveryx,

 

We posted the solution JSON file to Cloud Quest #11. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!

 

Let’s dive into this week's quest!

 

This week's challenge was inspired by a submission from @pawel_zych. Thank you for your contribution!

 

  1. Download the provided JSON file containing your starting data and workflow files.
  2. Upload the provided Cloud Quest 12 - Start File.json file into your Analytics Cloud library.
  3. All necessary datasets are contained within Text Input tools.

 

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.

 

Scenario:

 

In this week's quest, you are a procurement specialist about to begin negotiations with the suppliers of parts you need for your operation.

 

Your first dataset contains purchase orders from last year. Your second dataset contains forecasted demand for parts you need in the coming year, paired with the suppliers who can deliver them.

 

Your task is to create a “Negotiation File” to use while negotiating prices with your suppliers for the coming year. You want to create one record for each part even though you have previously purchased parts from multiple suppliers. Include a column that indicates the contribution percentage of each previous supplier for a given part.

 

Hint:

  1. Unlike Designer Desktop, the Summarize tool in Designer Cloud does not apply any kind of sorting to its output. You may need to sort your dataset prior to summarizing to get your expected result.

  2. The Round function will round to the nearest value in the multiplier. For Example:

    The result of Round( [31.19], 1 ) = 31.

    The result of Round( [31.19], 2 )  = 32.

    The result of Round( [31.19], 5 ) = 30.

 

Spoiler

A combination of the Join, Sort, Summarize, and Formula tools should help you create the file, but not necessarily in this sequence.

If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:

 

Once you have completed your quest, go back to your Analytics Cloud library.

  • Download your workflow solution file.
  • Include your JSON file and a screenshot of your workflow as attachments to your comment.

 

Here’s to a successful quest!

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

16 REPLIES 16
ggruccio
ACE Emeritus
ACE Emeritus

I may have rounded the results slightly differently than the solution, but close!

 

Spoiler
Screenshot 2024-07-10 163308.pngScreenshot 2024-07-10 170252.png

 

 

Qiu
21 - Polaris
21 - Polaris

Mine is also having slight difference about the percentage. And there is only one "Round" function so dont really know where went wrong.

Spoiler
Cloud Quest 12.png
JeffF
Alteryx
Alteryx

Some percentages don't match due to rounding error.

 

Spoiler
Quest12_JeffF.png
AYXAcademy
Alteryx
Alteryx

The Round function will round to the nearest value in the multiplier. For Example:

The result of Round( [31.19], 1 ) = 31.

The result of Round( [31.19], 2 )  = 32.

The result of Round( [31.19], 5 ) = 30.

 

I will add this information to the "hint" above.

JeffF
Alteryx
Alteryx

It looks like the Output Solution in the Start file is using a 2 in the Round function. e.g. Round( [value], 2 ). This seems wrong and explains why some of the percentages add up to more than 100%.

 

If I change my function to round to the nearest 2, it matches the provided solution.

alexnajm
17 - Castor
17 - Castor

Comfortable with my solution 😊

Spoiler
Quest 12 Photo.png
logdog0411
9 - Comet
Spoiler
Bellamy CQ 12.png

RWvanLeeuwen
11 - Bolide

Here's my take

Spoiler
Quest 12 - RWvL.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
スクリーンショット 2024-07-15 193013.png