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!
Macro Input, Macro Output, Control Parameter
Presented by: @JoeM
Love this video (also learning alteryx)!
Thanks for everything you do! Love watching and working through these videos along side of you!
\\ edit: I had run into an issue, but it was a simple novice mistake!
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:
Instead that way?
Thank you so much for any help.
@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.
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.
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.