This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
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