running a workflow twice based on two different inputs

Question

Hi Alteryx Community,

Need your help on this:

I need to run this workflow and compare the output based on two inputs (see arrows).

My idea is I need to copy and paste this entire workflow.

The first iteration is based on "PREVIEW"

The second iteration is based on "ACTUAL" after  manually select and change to field "ACTUAL"

Is there a more efficient way to to do this?

Thank you

alexa_diff_QLD_20210801.csv

YLYONG · Answer

does macro work if there are other input files (which doesn't need to be updated) within the macro?

YLYONG · Answer

Thank you @danilang  for your input.

I created input and output macros however something is not working in the workflow.

I have a number of input dataset in the workflow and does macro work in this situation?

danilang · Answer

Hi @YLYONG

You can copy the part that duplicates, i.e. all the tools after Select (38) and put them in a standard macro.  Then include the macro twice in your main workflow both connected to the output of the tool before Select (38).  In the configuration of the first macro select [Preview] as the the field to map to the input field. In the config of the second one map [Actual].  The macro will run twice and then you can join/union(depending of how you compare them) the outputs to validate the preview against the actual.

Dan