Need to Setup batch Macro

[jilsj]

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

[CoG]

What is your logic for Selecting columns?

[binuacs]

@jilsj one way of doing this

[jilsj]

@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

[binuacs · Accepted solution]

@jilsj updated workflow attached

[jilsj]

@binuacs Thanks for your Help. It's working