Alteryx Designer Desktop Discussions

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

Need to Setup batch Macro

jilsj
5 - Atom

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

 

5 REPLIES 5
CoG
14 - Magnetar

What is your logic for Selecting columns?

binuacs
21 - Polaris

@jilsj one way of doing this

image.png

jilsj
5 - Atom

@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 1Column 2Column 3
1AAS
2DAD
3XAD
4FSD
5ADS

 
Similarly, output  2 should have: Column fields 

Column 1Column 2Column 4
binuacs
21 - Polaris

@jilsj updated workflow attached

image.png

jilsj
5 - Atom

@binuacs Thanks for your Help. It's working

Labels
Top Solution Authors