Create a macro or automate a workflow?

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!

World bank data - macro tbd.yxmd

Workflow

Iterative Macro

Accepted answers

Claje

Hi,

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

Let me know if you still encounter issues!

claje_World bank data - macro tbd.yxzp

All comments

regisb

Sending the correct packaged file.

Thanks again!

World bank data - macro tbd.yxzp

Claje

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!

claje_World bank data - macro tbd.yxzp

regisb

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

Hi,

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

Let me know if you still encounter issues!

claje_World bank data - macro tbd.yxzp

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280