Help Needed: Macro to Extract Tool Data and Export to Excel
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Rao2821
7 - Meteor
‎08-30-2024
08:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to create a macro that can extract the tool ID, tool name, and all relevant information from the configuration window and output it into an Excel file. This macro should be designed to work with any workflow, generating the required results consistently. Could someone explain how to achieve this?
Labels:
- Labels:
- Macros
1 REPLY 1
Alteryx
‎08-30-2024
10:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You could try adapting the Parse Customer Managed Telemetry workflow from Help -> Sample Workflows -> Governance Enterprise Utilities. It essentially takes the whole XML that is stored for your workflow in the yxmd file and extracts and parses the tools from your workflows.
It's designed to operate on a telemetry folder, but you could adapt it to point at a single workflow.
