Assistance with Batch Macro

[ekavaline]

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!

[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.

I'd be happy to mock something up if you can provide some example data.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[ekavaline]

Sorry about that, I've attached the data.

[LordNeilLord · Accepted solution]

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

[ekavaline]

Wow, that was embarrassingly easy. Thank you!

[LordNeilLord]

Hey @ekavaline

Don't worry about it! Macro's can be somewhat confusing, so it may not always be that straight forward!

Glad you found what you needed.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome