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
I may want to redo this later. I'm happy with the first part of the workflow. The second part was a bit kluge-y, though I did get the correct answer. However, I sort of backed into it, so not really good practice
Spoiler
Process:
- Split to Columns by "|" and then by ","
- Dynamic Replace to change first record to field name
- Clean up
- Join by Order, Line, and Part
- Line Complete Status for Joined data is "Partial"
- Line Complete Status for Right Join data is "Line Complete"
- Union
- Initialise Order Complete Status as "Partial"
- Join with original Left Join data
- Set Line Complete Status to partial for those Lines from the original Left Join (as they are still open)
- Create temp field OrderNumber which is a string version of Order Number (to allow a find and replace)
- Find and Replace OrderNumber with Order Complete Status
- Correct the Order Complete Status for the two orders (4 and 7) that have open orders to Partial
- Clean-up
- Split to Columns by "|" and then by ","
- Dynamic Replace to change first record to field name
- Clean up
- Join by Order, Line, and Part
- Line Complete Status for Joined data is "Partial"
- Line Complete Status for Right Join data is "Line Complete"
- Union
- Initialise Order Complete Status as "Partial"
- Join with original Left Join data
- Set Line Complete Status to partial for those Lines from the original Left Join (as they are still open)
- Create temp field OrderNumber which is a string version of Order Number (to allow a find and replace)
- Find and Replace OrderNumber with Order Complete Status
- Correct the Order Complete Status for the two orders (4 and 7) that have open orders to Partial
- Clean-up
