Batch macro workflow not working - only output 1 record

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!

Batch macro problem.docx

Batch Macro

Accepted answers

JosephSerpis

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?

Consolidate scoping.yxzp

All comments

JosephSerpis

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

CharlieS

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.

JosephSerpis

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.

Sukisuki

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

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.

Consolidate scoping.yxmd

Macro_Read files.yxmc

Test files.zip

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235