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
It was fun solving this challenge. Keep an eye on the product ID data type for the final sort!😉
Got thrown for a while because I started when I was tired and made some early mistakes. All sorted now though
Spoiler
Process:
- Transpose inventory data
- Get Location ID
- Join with Sales data
- Union Join and Left Join (those with no sales)
- Get Quantity in Stock for records from Left Join
- Sort by Location and Product ID (not needed)
- Summarise data (sales and average sales)
- Calculate Order ETA date in lower thread and convert to Alteryx format
- Join with upper thread
- Calculate On Order Qty and rejoin with data
- Sort data and select first record (to remove duplicates)
- Union with Left Join data
- Clean-up
- Set data where no sales
Process:
- Transpose inventory data
- Get Location ID
- Join with Sales data
- Union Join and Left Join (those with no sales)
- Get Quantity in Stock for records from Left Join
- Sort by Location and Product ID (not needed)
- Summarise data (sales and average sales)
- Calculate Order ETA date in lower thread and convert to Alteryx format
- Join with upper thread
- Calculate On Order Qty and rejoin with data
- Sort data and select first record (to remove duplicates)
- Union with Left Join data
- Clean-up
- Set data where no sales
