Videos

Get your skills in gear with hours and hours of videos on topics ranging from beginner to advanced
New Course: Time Series Forecasting

Check out our four new lessons in the Data Science Learning Path that will help you stay entertained and learn some new skills while you're stuck at home!

Data Science Learning Path

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live! And don't forget to check out our Digital Costume Thread to get yourself in the mood for a candy binge!

Build Your First Batch Macro!

Highlighted
Alteryx Community Team
Alteryx Community Team

 

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
5 - Atom

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
8 - Asteroid

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
Alteryx Community Team
Alteryx Community Team

@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
8 - Asteroid

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
6 - Meteoroid

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

Highlighted
6 - 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.