Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Create a macro or automate a workflow?

regisb
7 - Meteor

Hi! I'm a newbie here. 

 

I'm trying to create a matrix by downloading several indicators (in this case from the world bank). To create a final file that put it all together, I had to copy and paste the same workflow 8 times, but I'm wondering if there is a way to create a macro that repeats these 6 steps or is there any way to simplify this process? 

 

Thanks!

image.png

 

 

 

5 REPLIES 5
regisb
7 - Meteor

Sending the correct packaged file.

Thanks again! 

Claje
14 - Magnetar

Hi,

I took advantage of a macro for my proposed solution @BenMoss' Cross Tab Real (with a minor tweak), but that was to handle your column names which include some special characters.  Otherwise, if all your excel files exist in one folder, you should not need any macros to repeat this functionality.  I added my version of the process at the top of the workflow and attached the package here.


Let me know if this helps, and if my solution makes sense!

regisb
7 - Meteor

Could you please send as compatible mode? I don't have the latest version (currently on 11.7) so it's not letting me open the file... 

 

Thanks! 

Claje
14 - Magnetar

Hi,

I think I correctly updated the new attached file to version 11.7

Let me know if you still encounter issues!

regisb
7 - Meteor

Thank you so much! 

My next goal: study cross-tabs!

Labels
Top Solution Authors