Hello,
I am creating a macro that consolidates files with different columns from a certain folder. The input files also has headers and footers that needs to be removed before consolidation.
The problem is that my macro does not loop through the different files in the directory. I'm not sure what I'm doing wrong.
I have set the macro to type = "Iterative Macro". Are there other switches that tell Alteryx to loop through the different input files?
I'm attaching my workflow with sample data in case anyone is interested.
Thank you!
DA
@data4actuaries
Typically a Batch macro should have a Control parameter, which is not seen in your macro.
I modified the workf and Macro as attached assuming your data is having same schema.
Two important points to note here.