I am tried your solution. It works very well for the first time. But when I try for the second time i have as error message : unable to open file for write.
How we can run woorkflow and regenerate the output???
any help please
This appends sometimes (probably a mis close of the document by Alteryx or Excel if you open it right after the workflow has ran).
A advise : don't open it right after the workflox has ran
To solve the problem, you just have to delete the file.
Couldn't figure out how to get the dropdown tool to display the list of unique Position Numbers I created, so I copy pasted them into the interface and set it to manual. Workflow in spoiler. App attached.