This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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?
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.