Scheduling dependent workflows

champ24

Hello,

I have an Alteryx workflow that transforms data and loads data into a database table. This is scheduled on a server. However, the challenge is to run update and delete statements on that table and then use that table as an input to and write to a hyperfile, without using in db connection (not allowed in our alteryx server).

I was thinking if I should use a block tool after the workflow is run and loads the data to table and then use a python tool to update and delete as a second step and then as a third step write the updated data to a hyperfile, just so the dependancy is not lost.

Wanted to hear the expert opinions. Any sample workflows are much appreciated.

TIA

OllieClarke

Hi @champ24

You can use pre-sql or post-sql queries in normal Data Input tools connected to a database. You could run a post-sql statement on the tool writing the table to update it (I'm not sure I fully understand what you mean by "delete and update statements").

I would then use Control Containers to ensure that this has all happened and completed before running another control container which loads in the updated table and writes to a hyper file. Block until done can't be trusted in this situation as it is only checking records passing through the tool, rather than processes happening outside of Alteryx (such as writing a table).

There's more info on control containers in their docs here and also in this blog by @smugabart

Hope that helps,

Ollie