Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Batch macro workflow not working - only output 1 record

Highlighted
5 - Atom

Hey, anyone can help me with my batch macro? I'm trying to use a batch macro to load multiple excel files within a folder. The workflow worked perfectly previously but somehow not working now. The folder (directory) has 3 excel files and each one has multiple records. When running the macro in the standard workflow, it only returned the first record of the first file and only one iteration was run. Attached are the screenshots of the workflow and also the configurations. Appreciate for any suggestions!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Sukisuki are you specifying the sheet name of the excel files that you feed into the Batch Macro? This article might help you. 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

If I were to guess, the only file that worked is the only one that has a "FY19 Scope List" sheet. The Directory tool will pass the file path, but not the sheet name(s) from that file. Your batch macro will need to know the sheet name so that can be updated for each file. 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Sukisuki if you don't know the sheet names then the solution of this post should help you as it finds the sheet name then updates the file name then puts through a batch macro.

Highlighted
5 - Atom

Thanks for the suggestion, I appended the sheet name to the file path to specify the sheet I'm looking for (which is sent to the macro as control parameter), is this correct? But I still have the same output (one record only).

Sukisuki_0-1581952654598.png

 

Highlighted
5 - Atom

Thanks for the quick reply. All test files have the "FY19 Scope List" sheet and they are in the same format. Attach here the workflows and test files for your reference.

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Sukisuki can you try again but take out the the single quotations marks and $ from the sheet name.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Sukisuki  thanks for your sharing your workflow I ended up having to rebuild your batch macro to make it work. Attached the workflow let me know what you think?

Labels