Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Batch Macro - File Must be Specified

Highlighted
7 - Meteor

Hi,

 

I'm looking to pull the same tab from many .xlsb files from a same directory, perform the same cleansing steps on the data from each file and combined all of the cleansed data.  Batch Macros seem like they should be able to handle this, but when I try to run my workflow, which has a directory tool feeding a fullpath into a batch macro, I receive a 'File Must be Specified' error.  My Macro consists of an input, update value with the file name selected, and input data tool, and then my data cleansing steps that apply to each file, before a final output tool.  Any guidance on what may be causing this issue?

 

Thanks!

 

Highlighted
Alteryx
Alteryx

@JeremyN Do you have a sample workflow, macro and file that you can share? It would help take a look at this issue.

Digan
Alteryx
Highlighted
Alteryx
Alteryx

Hi @JeremyN ,

A batch macro can certainly handle your use case. Another option that might work that does not require a batch macro is the Dynamic Input tool .  As long as each of the sheets have the same schema the Dynamic Input tool should do the trick allowing you to make all the edits at once. I have attached an example workflow (2018.4) that shows how this can be done.  Hope this helps!

Peter Stoddard
Premium Support Advisor
Alteryx, Inc.


Highlighted
7 - Meteor

It's actually kind of hard to share this file while providing sample data, but I was able to resolve the issue. 

 

One simple thing that was throwing me off when working with macros is that you may update the macro, but if you try to run a workflow referencing the macro before you save your updates, the workflow won't see them.  Remember to save your macro before running another workflow that references it!

Labels