you would need to create a loop (could be each Work Order ID and/or other values) with details of each Work Order, and within the loop perform the processing of the Status value against the Work Order ID.
The loop value would be a list of each Work Order ID e.g.
And the transform to extract these in the Loop Activity would be something like:
You therefore would need a mechanism to create the loop value, which could be a transform or a query that returns an output with the values required.
Retrieve The No. of WOs and use XSLT to set the counter value, which will write 'n' line (or data what you perform), which you'll get in previous responce as 'n' numbers.
just implement what Carl has suggested.
If you are having trouble for 'How to use For...Loop' then just watch this video: BAO Fundamentals - Loop & Token, Data Driven Execution - YouTube
see how the For...Loop is used and use the same way with the XML value you have for WorkOrderID's.