I have created a workbench with 3 bookmarks:
- a Creator/ProjectWise connector which downloads an Excel file from ProjectWise
- a processing workflow
- a second Creator/ProjectWise connector which initiates the upload of the spreadsheet
The idea being that I can write information about the data transformation step (2) into the spreadsheet and then upload it. The problem is that I can't control the sequence of events very well which means that the final step (step(3) - upload) occurs before my reader/transform/writer process (2) has had a chance to update the Excel file. I've tried setting the Creator order (no impact) and the tried a decelerator on Creator 2 but with the latter the whole workbench gets stalled.
Is there a way to control the workbench processing order without using multiple workspaces?