how roll-up 2 workflows that I would like to roll-up into 1 workflow.

igonzalez

Hello,

I created 2 workflows that I would like to roll-up into 1 workflow.

The first workflow pull database from a (table) DB2 database and imports into a SQL server database table where a stored procedure is run on the that table which in turn creates a new table (let's call table2 just for the example)

The second workflow uses table2 as an input and create an tableau output (tde file).

Currently I have to run workflow 1 and then workflow 2 manually.

I want to have 1 workflow that will use the DB2 table as an input to the the SQL output which applies a sproc on the table wich creates table2 that will then be used as an input to the tableau output (tde file).

I can do this in SSIS fairly easily but unfortunately my current employer doesn't have SSIS.

I have attached a screen shot of both packages.

Please advise

Best Regards

Ivan

DB2_SQL_SQL_TDE.docx

michael_treadwell

Gonzalez,

The Dynamic Input Tool is definitely what you want to use here but realize we are kind of using it to trick Alteryx.

Do this, take the workflow that you have already created and between the Block Until Done and the Dynamic Input insert a Formula Tool

With the Formula Tool, create a field called Dummy with type String

In the expression box simply type ''

Just two single quotes

Now, in your Dynamic Input Tool make sure 'Read a list of Data Sources is selected' and choose 'Field:' as Dummy and 'Action:' as 'Append Suffix to File/Table Name'

Then see if your module works