I am working on a use case that involves running a batch macro, but I’ve found it challenging due to the nature of my inputs, which are two distinct types: "data" and "requirements."
- The "data" inputs are Excel files in a specific input folder.
- The "requirements" file specifies which data files need to be analyzed and the criteria for each.
Although the input folder might contain additional files, I need to process only the specific files listed in the "requirements" file.
I’ve completed the criteria testing within the `FilterAndRender` macro. My goal is to process the files one by one, based on the unique entries in the requirements file until all specified files have been processed.
I have attached the Alteryx Workflow Package (.yxzp) file, which includes all necessary inputs, macros, and an example output.
The final output should be a single Excel Workbook (.xlsx), with each processed file’s results saved in separate tabs, named after the corresponding input file.
