Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #179: Calculating Order Status

Highlighted
Alteryx Partner

179_Sihle.PNG

Highlighted
Alteryx Partner

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

MySolution.PNG

 

 

Highlighted
Alteryx Partner
Spoiler
jv1_0-1577715043057.png
Highlighted
Meteor
 
Highlighted
Asteroid

agreeing with some of the people on here that line 12 is complete so here is my solution 

 

Spoiler
Carlithian_0-1579190253095.png
Highlighted
Asteroid

Great fun

Highlighted
Asteroid
 
Highlighted
Alteryx Partner

Same issue with order 8 as others.

Spoiler
dsmdavid_0-1581292567168.png
Highlighted

Got confused initially then figured it out...

Highlighted
Asteroid
Spoiler
Challenge 179 2020-02-20.jpg