community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Batch Macro: Multiple directory inputs into one macro possible?

Meteor

Hi -

 

I have a batch macro workflow with files from two directories I'd like to flow through. Is it possible to set up the macro to accept two different directory tools?

 

Thanks.

Bolide

Hi @jannis005, is not possible to just union the two directory inputs together and push them through the batch macro that way? If not, could you maybe explain what you are trying to accomplish with the batch macro?

Meteor

Basically I have two separate directories of files that I want compare an amount from one data source to the other and calculate variances.  Ideally, I'd feed in one file's directories into one input in the macro and feed the other directory through the other input on the macro. Is there a way to join the two files together into separate tabs, and then separate the tabs in my workflow in the macro based on sheet name?

Bolide

Hey @jannis005, would it be possible to attach your workflow, so I can better see what you're trying to do?

Quasar

Hi @jannis005!

 

I'm also having trouble picturing what you're trying to accomplish, but one post came to mind when I read your question. I recently used this approach to bring the sheet names into my workflow.

 

Check out the Directory macro by @LordNeilLord in this post:

Get worksheet names from excel

 

 

Meteor

Thanks for the response. I'm not sure what the best way to provide dummy data in my workflow without muddying what I am trying to do, but basically in my macro workflow I have two control parameters going into input files where my data sources are. When I create an additional workflow with the macro inserted, the macro tool only has one input so I can't connect it to two directories. Hopefully the screenshots will help.

Workflow shot 1.PNG

 

 

 

 

 

 

 

 

 

 

 

Workflow shot 2.PNG

Labels