Execute Tools after Output succeeds

Hello everyone,

We're facing a situation at my company and we are not sure if what we ask for is feasible.

CONTEXT

We are thinking about developing a custom execution log for a few Workflows that we have scheduled in the gallery. This would imply writing to a log table in our SQL Server after the normal output in the Workflow has finished successfully.

PROBLEM

We are unaware of how to make a flow continue after an output. I think the following picture presents the problem in a quite obvious way.

Could someone give us a helping hand and show us any way to achieve the desired flow control requirement?

Best regards,

Workflow

Output

Tips and Tricks

Chained App

Accepted answers

All comments

NickC

Hello Pablo,

Try using the block until done tool. This will ensure that the first output is completed before the 2nd and 3rd run.

Nick

bharti_dalal

hi @pablo_martin,

once you have written data in output tool it is saved in you system. if you want to use that data further bring a input tool and upload the file. But why do need to write it in output tool everytime? just take the input from the tool preceeding the o/p tool and move further.

pablo_martin

Hi,

Thanks for your answer. We are aware of the Block Until Done tool, but the main data flow and our logging dataflow are independent, and thus it makes no sense to put both of them together in the Block Until Done.

Somehow, we need to use the Flow control capability of that tool while having two separarte data flows that can't be joined together to enter the tool.

Any suggestions?

pablo_martin

Hi Bharti,

It is not the same data that should be written in both output tools. The workflows have two independent data streams, and what I would like to achieve is simply making sure that the second output is only written if the first one is successful.

Best regards,

ak2018

I know this is an old question... I had to write multiple datasets one after the other, I did use the Block Until Done tool but added a flag field using the Formula tool to identify where the flow should go and then before the output tool, use a filter to allow the rows that need to go in and a data cleanse tool to drop null rows and columns. If your fields are fixed, you can add a select tool to ensure no other columns come in.

Alternatively, you can use the JOIN tool on the said flag fields and use the outer join of the data set you want to pass, that way the rows from the other data flow do not come in. I know this is a bit circuitous but it worked well for me.

Alex98970

Hey Guys was this resolved. I am trying to implement similar kind of thing:

Once data is loaded into my table - > I want to run stored proc to populate other tables.

I am using Snowflake as the database

Mchappell67

Hi -

This solution came to my attention recently:

Turn each workflow into an analytic app, then follow the directions in the linked interactive lesson below for Chaining Analytic Apps: https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120
ii. To turn a workflow into an app, click on the Workflow tab of the configuration window, and click the radio button for Analytic App, and then save the workflow.

Perhaps that would work for you.

Mark

Alex98970

Thanks Mark. What do you think of crew macros ?

Can this is used ?

Regards

Mchappell67

Hi -

Unfortunately, I have not seen the Crew macros in action, yet, so not really in a position to comment. The solution that I linked to above seems to be a simple way of linking workflows, but may not be powerful enough for you.

Mark

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703