Run one process after another

Question

Hi,

I have around 12 individual SELECT queries. When Parameters are given, each of this query will pull data from Oracle and then INSERT into a different table.

First query will pull data from Table 1, filters data, inserts into Table 2

Second query will pull data from Table 2, joins with other tables and filters data, then inserts into Table 3

Third query will pull data from Table 3, joins with other tables and filters data, then inserts into Table 4

etc

So, each query should be run one after another. I use Dynamic Input Tool to connect to Oracle Table 1, copy paste the first query, then use output tool to Insert data into Table 2.

For the second process, I use second Dynamic Input Tool to connect to Oracle Table 2, copy paste the second query, then use second output tool to Insert data into Table 3. etc

As these process needs to run one after one, I am using Block Until Done connected to multiple block until done which connects to Dynamic input tool. Is there  better method to achieve the requirement?

Thank You

PedrodeOl · Answer

@Reddy4 ,

A batch macro should be a good approach. Look the dummy example I've attached, there is a text input tool with the table combinations in/out you want to do + an update on the input data/output data query/insert parameters.

dynamic_in_out.yxzp

Reddy4 · Answer

@PedrodeOl ,

For governance purpose we use 'database connection share' feature to add the database connections on the server level.

All accessible databases connections can be found in Alteryx Designer > Options> Advanced options > Manage Data Connections.

As we use Database Connection share feature, we cannot use in-db tools.

Can you give me a sample workflow using dynamic input tools?

PedrodeOl · Answer

@Reddy4 ,

Instead dynamic input you could try:

formula tool (to write your queries and path to credentials) + dynamic input in-db + write data in-db.

This approach should work better.