Output data in 2 different sheets

Hi,

I want to get the output in a workbook in two different sheets. Actually, I am checking the data based on some criteria, so if the data is meeting the criteria, it should be in sheet1 and if it is not meeting the criteria then it should go in sheet2. I need help how we can do this. I have attached my sample workflow where 1st end is Multiple join tool which should go in sheet1 and 2nd end is union tool which should go in sheet2 in the same workbook.

I thought to use block until done, but it has only one input anchor. I tried to union my data before using block until done but it would mix my data which is meeting the criteria or not.

Any help, would be appreciated.

Output in different sheets.yxzp

Workflow

Output

Accepted answers

AngelosPachis

Hi @Rahul_Analyst ,

To force your multiple join output to happen first, you can use a combo of a block until done tool and an append fields tool to orchestrate which output happens first. As shown below, your multiple join output feeds into a block until done tool and all records are fed to the output.

Then you have to stall the union output to happen after the multiple join one, so you have to form a "connection" between the two. That you can do by appending the first cell of the first column to your union dataset and then dropping it in the append fields tool. Your union output will only start when the appends fields tool has done it's thing, stalling your workflow down

Hope that helps,

Angelos

Output in different sheets.yxmd

AngelosPachis

@PhilipMannering maybe but using two Block Until Done tools you infer that one of the two will happen before the other and not simultaneously, which depends on the number of records passing through its tool.