Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Cloud Quests
Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.
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.
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.
