Macro help needed for changing inputs automatically

Hi,

I have a workflow which has two inputs - Train no and origin as shown in the screenshot. The workflow is ready and has to be run with the input of path 1 for train no and origin for the output of path 1. This has to be done for all 10 paths. Instead of changing input for each path and running the workflow 10 times, how can I use a macro to automate it as I have over 300 paths? Would save considerable time if it could be automated.

Train for	Path1	Path2	Path 3	Path 4	Path 5	Path 6	Path 7	Path 8	Path 9	Path 10
	11274	13712	12698	14955	14692	13950	12002	13523	14342	13250


Origin station for	Path1	Path2	Path 3	Path 4	Path 5	Path 6	Path 7	Path 8	Path 9	Path 10
	CSMT	NDLS	NZM	DLI	AI	MAU	BDTS	CZM	DEE	DEC

Thanks in advance,

Suvasini

Macros

Accepted answers

messi007

@Suvasini,

Attached the workflow and the macro.

yxmc: is the macro and yxmd is the workflow.

Please save them under the same folder and then open the .yxmd file.

Hope that helps,

Regards,

batch.yxmc

New WorkflowBatch.yxmd

All comments

rkapoor

@Suvasini you can do this via a Batch Macro where the Path is your Control Parameter ie the group you want to repeat the workflow/logic for.

This article by @EricWe is a great one to get you started:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165

messi007

@Suvasini,

Let's imagine that you need to filter each path and run the process as you said:

Below the batch macro that will allow you to filter:

Below the workflow that will call this macro with the inputs and one column that contains all the path:

Attached the workflow,

don't forget to update the question for the batch input:

If this solves your issue please mark the answer as correct, it will help others!

Regards,

New WorkflowBatch.yxzp

Suvasini

Hi @messi007

Firstly thankyou for the detailed explanation. I need the workflow to run with the train and origin output of path 1 entirely, generate the output and then run it again for path 2 train and origin. From what I researched, I believe an iterative macro does this. Request you to kindly help me in that scenario. Appreciate the help, thanks again.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703