Assistance with macro/ solution

[Apizzacake]

Hi community, 

I have created a workflow whereby it is reliant on 1 input file with 1 cell. for e.g. Account number 300000.

I would like to incorporate a macro whereby this input file with 1 cell is ran multiple times with this 1 cell changing its value but I am not sure how to go about it. I have tried reading up on batch macros but I am unable to get the outcome of what i desire.

e.g. if you refer to my sample workflow, the first text input is to be put into the workflow, and each line is to be ran with the figure changing. 

Please kindly  assist or let me know if unclear. (Ultimately i want the workflow to run 3 times with the account number changing 3 times based on my input data which could be a simple excel input file)

[Qiu]

@Apizzacake 
If I understand your intention here correctly, you want to go through each account number and perform some calculation, then yes, we should use a batch macro.

[Apizzacake]

hi @Qiu 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/To-run-the-same-workflow-multi...

Similar to attached post. What I want is the workflow to be ran multiple times with the account number changing. For e.g. once with account number 
222345, once with account number 000345 and once with account number 555155

[Qiu · Accepted solution]

@Apizzacake 
Thats what I have interpreted, and we can use the batch macro as I have shown in my last reply.

[Apizzacake · Accepted solution]

Hi @Qiu with reference to my workflow, based on what you have sent me the workflow only runs 1 time. What I require is something similar to each container but instead of creating 3 containers, the batch macro changes 1 value inside the workflow and it runs it multiple times. 

[Gaurav_Dhama_ · Accepted solution]

Hi @Apizzacake , you just need to add these steps inside the batch macro. I updated the macro that @Qiu provided, let us know if this is what you were expecting.

[Apizzacake]

Hi @Qiu  @Gaurav_Dhama_  thank you  both so much!!! yes this is what I wanted. Much appreciated