Create a macro or automate a workflow?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Iterative Macro
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much!
My next goal: study cross-tabs!