Assistance with Batch Macro

Hey, newbie here. I've looked at one live training on batch macros and some help pages, but I'm stuck and hope someone can help me with this.

The goal is to clean FAFSA data, but each week of data must be cleaned individually before being unioned. Because they are all cleaned the same way, I'm not sure what to have as an action. I'm not even 100% sure if a batch macro is the appropriate tool. So any suggestions are welcome. I've attached my work so you can get a better of idea of what I'm trying to do.

Thanks!

fafsa.yxzp

FSA FAFSA.7z

Macros

Accepted answers

LordNeilLord

Hey @ekavaline

Sorry for the slow reply.

Seeing as you had already done the hard work of building the macro, here's how you can get it to work for each sheet...

Choose filename on the input screen:

Then use this new column as your grouping field on the batch macro:

This will process each file individually and then union them all together as a single output

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

All comments

LordNeilLord

Hey @ekavaline

The sheets weren't included in the package so I'm guessing here but looking at what the macro is doing I don't think you need to overcomplicate it with a batch macro...I think you can just use a normal workflow and make use of the grouping functions that most tools have.