Writing to excel file - different sheets - 3 different streams / The process cannot acce
- 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
Hi
I have this workflow, and i have 3 different streams that I want to output to the same excel file.
I tried adding a block until done, tho I think that would only work if I had only 1 stream.
So what to do?
Solved! Go to Solution.
- Labels:
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Hamder83
You can use Wait A Second macro and set the timer to write one after other
https://community.alteryx.com/t5/Engine-Works/Crew-Macro-Pack-2016-Q2-Release/ba-p/26482
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Hamder83
I am assuming you are writting to an Excel file with different sheets?
If yes, then maybe we can put the the Block and Done Tool after the first Formula tool on the most left side of your flow.
so it can be sure that only the writting process is completed then move to the seond stream.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Hamder83
Yes, I agree with @Qiu adding block until done at the diverging part should work somehow I looked past it. If it doesn't you can give macros on that page a look.
https://community.alteryx.com/t5/Engine-Works/Crew-Macro-Pack-2016-Q2-Release/ba-p/26482
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can I give you both the credit for the solution?
Because yea block until done as Qiu puposed is a good choice.
but i didnt know of the macro, and that helps me solve several other issues we have :-)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Hamder83
Yes, sure you can. You are always allowed to accept more than one solutions.
Happy to help 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @Hamder83
Cheers and have a nice day!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Hamder83
Glad to help and thank you for the accept mark
