Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask here!
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
My solution is pretty similar to a lot of the others.
A couple of hints, if you were confused about the requirements like I was!
Spoiler
1 - The output should only contain lines that have something shipped
2 - The Qty in the output should be the order quantity if nothing has shipped, or the shipped quantity if something has shipped.
3 - If something exists in the Open Orders table, then the line status is Partial (even if the shipment quantity matches). I'm not sure how it's possible to have an order qty of 1 and a shipped qty of 1 and still be open, but that's how it appears to work! In other words, if a line exists at all in Open Orders, then it is not totally fulfilled yet.
2 - The Qty in the output should be the order quantity if nothing has shipped, or the shipped quantity if something has shipped.
3 - If something exists in the Open Orders table, then the line status is Partial (even if the shipment quantity matches). I'm not sure how it's possible to have an order qty of 1 and a shipped qty of 1 and still be open, but that's how it appears to work! In other words, if a line exists at all in Open Orders, then it is not totally fulfilled yet.
My workflow:
Honestly had a hard time understanding the description (seems I'm not the only one!) but ended up getting there.
