We posted the solution JSON file to Cloud Quest #33. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!
For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update. This week’s challenge comes from @bdelarosa—thanks for the awesome contribution!
For this Cloud Quest, your task is to organize the provided input data so it clearly shows:
Be sure to display all inventory records, even if there haven’t been any sales or purchase orders for that product.
Hint: Use the Join Multiple tool to bring the datasets together—this will streamline your summaries process.
After completing your quest, head back to your Analytics Cloud library:
- The Academy Team
Here's my take
It looks like everyone is busy with Inspire. 😁
Solved.
I had some trouble matching the solution. It looks like some of the solution values are 2x, 3x, or 4x of what they should be. I think the problem is that the Solution file doesn't Summarize the data that's on order. If the same Location/Product has been ordered multiple times, we end up doubling/etc the Units Sold and Current Inventory - @AYXAcademy
Solution file showing the Cartesian join:
Mine:
Done!