Multiple outputs from filter tool

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

Workflow

Output

Accepted answers

benakesh

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.

sheet1.yxmd

All comments

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

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.

sheet1.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703