community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

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!

Alteryx Certified Partner

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


Data Lover

Sorry about that, I've attached the data.

Alteryx Certified Partner

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:

 

Batch1.PNG

 

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

 

Batch2.PNG

 

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

Highlighted

Wow, that was embarrassingly easy. Thank you!

Alteryx Certified Partner

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


Data Lover

Labels