Block Until Done & Filter Tool

[danielmaguire]

Hi,

I am outputting both T and F anchors from the filter tool directly into the same excel, T is one sheet, F is the other. I am receiving the error that F can't write the sheet because it is open. How can I implement the block until done tool in this use case given the two inputs required? Unfortunately the use case cannot use any macros, so any solutions would be greatly appreciated which results in two sheets being created. I can't share the workflow due to the sensitive information, but please see snippet of use case.

Thanks,

Daniel

[shreyanshrathod · Accepted solution]

Hi @danielmaguire ,

Hope this helps.

Regards,

Shreyansh Rathod

[Emil_Kos]

Hi @danielmaguire,

Actually, I am not sure if you need a filter tool or even a block until done tool. 

You can pick change the entire file path or the file name to make it work. I hope this helps. 

[danielmaguire]

Hi @Emil_Kos 

Thanks for this solution.

If I use this solution, can I rename the sheet, or does the sheet have to be the field name?

Thanks,

Daniel

[Emil_Kos]

Hi @danielmaguire ,

Most of the time when I have used this approach was when I wanted to split the data by region for example.

I could use the region column to split the data into the sheets that have the region name in the column.

I believe you want to achieve something similar. You can split the data by sheets in a very similar manner to the filter tool.  

Does that make sense? 

[danielmaguire]

Thanks, yes that makes sense. I think for my use case the filter approach will be needed. Thanks to all for help!