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
