Control Containers to Create a New Workbook & Update Different Sheets on the same workbook
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello.
I am trying to create a workflow where a new workbook is created (in a shared network drive) with current date, and the same workbook has sheets updated with other parts of the workflow.
Recently came across Control Containers and thought it would do the job, but its been a hit or miss, where sometimes it runs without issues, but most of the time, I get the error that "The process cannot access the file because it is being used by another process."
Below is a sample of the workflow I am using.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'd put the other tools in each of their respective control containers and see if that fixes it!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Tried that earlier as well, but didn't have any difference in the order of execution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Gotcha. Personally what I'd do instead is have a Block Until Done tool right after that Select tool and have each of the three branches going out of the 1, 2, and 3 anchors respectively
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That was my first option. But for some reason, even after using a Parallel Block macro, it still updates the next sheet before the first process completes.
The workflow is updating into a shared network folder, where I am creating a new file based on the current date, with sheet 1 data of 100K records. I have the same formula for the sequential workflows that create a new sheet in the same file and update with just about 100 records.
Could it be the difference in number of records that's causing it? Or that it's writing onto a shared drive? Or maybe because I have the same~ formulas for creating the file name using formula tool for multiple sheets?
I have tried the following, but not sure if I'm making a mistake someplace.
1) Regular Block until done
2) Union with dynamic output tool
3) Parallel Block until done macro
4) Control container
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is AMP Engine turned on with the Block until Done option? I would turn it off. Otherwise getting screenshots of your configurations would be great
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A few things:
1) that workflow looks a lot different to the original workflow. What a screenshot with your workflow configured with the block until done tool only?
2) it looks like you are doing create a new sheet - that will work the first time but not each subsequent run (I’m assuming your path is updating based on the say) - overwrite sheet should work better.
3) I’m not sure those are parallel block until done macros as they are different icons so I can’t confirm if those have the correct logic
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The network drive could be part of the issue - you could try the wait a second tool for each stream to help out. Otherwise, I don’t know how much further I can help unless you send over the packaged workflow!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'll try the wait a second tool and get back to you! Thanks so much for all the help and suggestions! :)
Do you know if the Wait a second macro would be OK to use on the Alteryx Server? Or will there be restrictions?
Thanks.
