Cloud Quest #12: Supply Chain Negotiation

[AYXAcademy]

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:

• Getting Started with Designer Cloud
• Building Connections in Designer Cloud
• Building Your Workflow in Designer Cloud

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!

[mshishido]

fun one

[geoff_zath]

Solution attached for Standard mode tools.

Spoiler

 

[tshih18]

Had to make sure with provided solution that I used the correct multiplier for Round()

Spoiler

[mceleavey]

A bit of concatenatey magic.

Spoiler

I first created a sum of units per part number and joined it back so I had this in a new field.
I then calculated the % of prior and smooshed it together with the supplier name using a formula tool. I then used a Sum tool to group by the part number and concatenated the Supplier % of prior and joined the second dataset to give me the rest of the data. I had to ensure it was sorted correctly before the concatenate to get the exact answer.

[patrick_digan]

Spoiler

[TonyaS]

I also made an app in App Builder. 

Spoiler