Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more 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

Challenge #179: Calculating Order Status

Sihlex1
7 - Meteor

179_Sihle.PNG

SueDonim
8 - Asteroid

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

 

 

jv1
8 - Asteroid
Spoiler
jv1_0-1577715043057.png
GaurVitul
7 - Meteor
 
Carlithian
11 - Bolide
11 - Bolide

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

 

Spoiler
Carlithian_0-1579190253095.png
AndyBate
8 - Asteroid

Great fun

rmassambane
10 - Fireball
 
dsmdavid
11 - Bolide

Same issue with order 8 as others.

Spoiler
dsmdavid_0-1581292567168.png
Pushpita15
5 - Atom

Got confused initially then figured it out...

danicahui
8 - Asteroid
Spoiler
Challenge 179 2020-02-20.jpg