Need to Setup batch Macro
- 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 All,
Please help me on setting up one batch macro for below requirement.
This is just sample data the actual use case have close to 100 plus columns and I need to generate multiple batches of output in similar way given below.
the below Excel dataset that I need to split into three distinct outputs using Alteryx. Columns 1 and 2 should appear in each output, while Columns 3, 4, and 5 should be dynamically included based on control parameters provided in the main workflow. Ideally, I plan to create a batch macro to generate these outputs according to the specified inputs in the main workflow.
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
1 | A | AS | FD | AA |
2 | D | AD | AD | SS |
3 | X | AD | SS | SS |
4 | F | SD | WW | WW |
5 | A | DS | SQ | SS |
Solved! Go to Solution.
- Labels:
- Batch Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What is your logic for Selecting columns?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jilsj one way of doing this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Thanks for your response. I am trying to split Columns fields not rows.
For example, the output should come like this.
Output 1:
Column 1 | Column 2 | Column 3 |
1 | A | AS |
2 | D | AD |
3 | X | AD |
4 | F | SD |
5 | A | DS |
Similarly, output 2 should have: Column fields
Column 1 | Column 2 | Column 4 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jilsj updated workflow attached
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Thanks for your Help. It's working
