Videos

Get your skills in gear with hours and hours of videos on topics ranging from beginner to advanced
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Build Your First Batch Macro!

Director, Customer Enablement
Director, Customer Enablement

 

Batch macros can be intimidating, but the intention of this course is to dispell your worries. Learn when to consider a batch macro, identify pre-existing processes that could be turned into batch macros,  and create your very first batch macro! 

Featured Tools:
Macro Input, Macro Output, Control Parameter

 

Date: 2018-04-18

Version: 11.0

Presented by@JoeM

 

Highlighted

Very nice session Joe,

I think the use of: Control Parameters, Action Tools, as well as Dynamic Rename added to the value of this training session. Thanks so very much! 

Vincent

Highlighted
Alteryx Certified Partner

Hi Joe! 

 

Love this video (also learning alteryx)! 

 

Thanks for everything you do! Love watching and working through these videos along side of you!

 

rock on,

 

Cameron Odonnell

 

\\ edit: I had run into an issue, but it was a simple novice mistake!

Highlighted

Hello @JoeM,

 

Thank you so much for your brilliant explanation!

 

I am studying for the advanced certification and I am trying to understand why the macro "Count Records" was made in that way:

countrecords.png

Instead that way?

mycountrecord.png

 

Thank you so much for any help.

Best regards,

Antonio

Highlighted
Director, Customer Enablement
Director, Customer Enablement

@AntonioGonzales great question! The count records tool needed to accommodate two basic conditions:

1) Create a N count of records if records exist

2) Return 0 if no records exist

 

If you run a count via the summarize tool and no records are counted, it does not output 0 but rather nothing, since nothing was there to be counted.

Summarize counting no records = nothing!Summarize counting no records = nothing!

To circumnavigate this behavior, you'll see the text input tool setup as just 0 - so if no count returns from the summarize above it, it will become the output value. If something is returned from the summarize, you'll see that it is ordered so the 0 will always be sampled out.

 

Highlighted

Hi @JoeM,

 

As always, your explanation taught me a lot!

Now, everything makes sense.

 

 

Thank you and have a great day!

 

Cheers!

Antonio Alves

Highlighted
Alteryx Partner

Very clearly explained, thank you!

Highlighted
Meteoroid

So well explained! This is by far the best session for batch macros. Thank you for sharing this. 

Highlighted
Meteoroid

Very interesting lesson! I surly need to watch it couple time more, but i think i have a particular situation where i do not have a unique DB ready to be divided into batches.

I would like to be able to apply the same process to multiple DB and I think the batch macro is what I need.

But how i can make the macro understand that the batch should be let's say the name/source of the file and the length the entire file?

 

To give more context: i have 150+ different DB related to different entities. However in these file i do not have an entire column with the code/name of the entity, but this information can be found at the end of each file. I have built a standard macro to make the process. 

Now i wanted to go further and be able to apply it on all 150+ file I have in a directory without applying the macro 150+ times.