Multiple outputs from filter tool

[rajputakansha]

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

[smoskowitz]

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

[benakesh · Accepted solution]

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.

[Vijuzy]

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