Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Batch Macro to multiple outputs (without union)

Highlighted
7 - Meteor

Greetings guys,

Hope that you're all doing well.

 

I am trying to create a workflow that takes a bunch of excel files full path (along with the sheet name) and inputs it into a batch macro that does some manipulation on the data and outputs each file in a different output without unionizing all the files, However, I am having trouble doing the last step as it unions all the files in the same output. I attached a picture of the workflow inside the batch macro.

 
 

Any help is appreciated!

Thanks guys

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Faresghnaim,

 

You're going to need to tick the checkbox at the bottom of your output tool "Take file name / table name from field" and select "change entire file path"  and select your Filename column in the dropdown (keep field in output).

 

image.png

 

I've attached my workflow for you to download if needed. If this solves your issue please mark the answer as correct, if not let me know!

 

Regards,

Jonathan

Highlighted
7 - Meteor

Thank you very much  for taking the time to help @Jonathan-Sherman !

This was exactly what I am looking for.

Labels