Reduce repetitive workflows

thuyduongnguyen

Hello Alteryx Community,

I have built a workflow (in red rectangle below) which dynamically change the Output file's name based on: Today's date + [Location] and still preserve the output formating.

Currently I replicate this process 6 times as I have 6 different [Location] in my dataset.

I want to reduce my current workflow and make it look more neat.

Here is a simple way to describe the purpose of my workflow:

Here is my current workflow:

I have been searching for the solution but has not found the one that works for my case yet.

I have tried to use Standard Macro but doesn't work.

It doesn't seem to serve the same purpose as mine. (Or I haven't exploit all its function yet)

Thus, there are more than 100 columns in my real file, "Append" tool is included there and these repetitive workflows lie in the last part of the whole process.

I attach my demo workflow and demo input/output as well.

Hope anyone also has similar experience can share your idea.

Thank you very much in advance.

output template for blod.xlsx

processing file - Kopie.xlsx

demo.yxmd

AkimasaKajitani

Hi @thuyduongnguyen 

I take the screenshot of my configuration. Please refer it.

The macro input tool requires sample data that is actually entered.

At the very least, it needs that the fields are used for calculations or filter in the macro.

The simple way to do this is to copy the data to be entered into the macro, paste it into the canvas from the right-click menu, and then click "Convert to Macro Input".

One more thing.

To work the Macros or workflows at older version Designer, you can open them by Notepad or something similar text editor and rewrite the version information from newer version into older version.