How to combine or consolidate 3 or more Workflows in a single one

I have 3 or more workflows that use the same source different formulas and calculations but the same output excel file with the same columns.

How can I combine or consolidate those workflow files into a single one?

Does any help please?

As you notice, I'm a new user of this wonderful and powerful tool.

Regards,

Gilberto

Developer Tools

Accepted answers

echuong1

So it actually looks like you'd want to keep all of the outputs separate.

I combined the workflows into one for you so everything is on the same canvas. It looks like a lot of the steps at the beginning are the same, so I consolidated those as well.

Hope this helps!

consolidated.yxwz

marcusblackhill

Hey @glombard !

You have the option in output tool to "create new sheet", so you just need to point all 3 outputs to the same file and choose different sheet name for each one with that output configuration "create new sheet".

echuong1

You can configure all of the outputs to the same file, and have the sheet names correspond with each output.

See attached for the updated workflow.

If this resolves your issue, please mark the solution as complete so others can find answers more easily.

consolidated.yxwz

All comments

echuong1

You can combine them into 1 by copy and pasting them onto a single canvas. From there, you can remove the redundant input tools and connect all of your streams from the one.

Your streams of different calculations can then be consolidated with a union tool at the very end prior to the output.

Are you able to upload a couple of your workflows? I can help mock a workflow.

glombard

Hi @echuong1

Thank you for your answer and help.

Please find attached some examples of workflows that I have to consolidate into a single one.

Regards,

Gilberto

US 401K Payroll Salaried Accrual Report.yxwz

US Payroll Weekly Accrual Report.yxwz

US TAX Payroll Salaried Accrual Report.yxwz

echuong1

Here is a simple example.

New Workflow13.yxzp

marcusblackhill

Hey @glombard !

Well, for me looks like @echuong1 said, so you can follow the steps:

Open all workflows;
Select all tools of second app (ctrl+a), copy and paste in the first app;
Do the step 2 again but with the third app;
Remove input of the second and third apps part and link those parts with the first app input

Now for the output, depends what you need, if the 3 parts need to output to the same file, you will need to save in different sheets or if need to put all in the same sheet, you will need to put a Union tool linked from all parts and that union will output to only one output tool instead of 3.

Hope that help you!

echuong1

So it actually looks like you'd want to keep all of the outputs separate.

I combined the workflows into one for you so everything is on the same canvas. It looks like a lot of the steps at the beginning are the same, so I consolidated those as well.

Hope this helps!

consolidated.yxwz

glombard

hi @echuong1

Your solution looks like what I'm looking for.

Now, my question is how can I consolidate the information on a single excel file with 3 or more pages on it for each calculation output.

Regards,

Gilberto

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703