Multiple outputs from filter tool
- 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,
Not sure if this question is asked before.
I am trying to get two outputs from each output of a filter tool. Both the outputs should be different tabs of the same file.
I am getting an error: Process cannot access the file because its being used by another process.
I have tried all the Output Options.
Can someone help?
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That happens if you are trying to write the "T" and "F" to the same file. This can be a little tricky depending on your data but look into the Block Until Done tool. I hope that helps.
Seth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @rajputakansha ,
Instead of filter use formula to create sheet name i.e sheet1 ( null comments ) and sheet2 ( valid comments ) .
In output configurations use 'take file/table from field' and 'change file/table name' .
Check 'one file multiple sheets' output in attached wf.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use what @benakesh mentioned as solution or you can use Crew macro called Parallel block until done to solve your issue.
Regards,
Vijay