Macro (Repeat 100 times an output without update values)

[Alex96]

Hello!

Hope you are doing well.

I need a little help here... I have a workflow that basically cleans "reversals transactions", but it doesn't clean all reversals in one act, because there are lots of reversals and I have to organize them in a way that I have to make sure that only reversals will come out.

I just need a macro that only repeats the output of my workflow 100x, without adding anything, just repeat my workflow (making the output as the new input in my workflow) regardless the condition.

I have saw many iterative, batch macros, tried to apply them, but I didn't succeed...

Can anybody help me, please?

[caltang]

I'm not sure what you're trying to achieve here...

If you are manually changing something 100x, wouldn't it be better to not have an output at all until you are satisfied or until number of changes = 100? 

The macro closest to this "logic" is the iterative macro, which can either stop at a desired outcome or stop at an "N" value (number of iterations). 

Based on your explanation, the "reversals" are not embedded with logic flows within Alteryx, but outside of Alteryx - meaning that you or your team actually change the inputs from the outputs, until you reach a desired output fit for purpose.

If I am understanding you correctly, then you may not need a macro to do this. Just have two containers at the start, one called #1 1st Input and #2 Subsequent Outputs + one container for your output (1 excel file .xlsx).

Once you run that first time, turn off the output, then change the input from #1 to #2, whereby #2 points to your 1st output file. Then keep iterating the changes within Alteryx per run until you are satisfied, then you can output your final file with a different output file. 

Regardless, kindly provide some sample data, expected outputs, and nice-to-haves in your workflow. The community will be better able to assist you.