Slowly getting to the end of Week 3, a day before the Alteryx Core Exam.  Last few days we practiced what we already learnt, and got a handful of good ideas, know-hows, and best practices from Angelos. We were started to gain a bit of confidence, but was time to learn something new. Alteryx again, but this time Macros. Let’s dive in what are they, why do we use them? Just a little catch up, in case you can't find your notes.

Essentially a Macro is one or more Alteryx workflow compressed into a tool, also a non-coder Software Developer's Kit.

· Allows us to standardize processes

· Can be configured with questions that the users answers to dynamically configure the macro

· A lot of existing tools are actually macros

Standard macro: This macro is designed to package a process in a workflow as a tool that can be inserted in a workflow. Batch macro: This macro runs multiple times in a workflow and creates an output after each run. The macro runs once for each record or selected group of records in data.

Batch macro: runs multiple times in a workflow and creates an output after each run. The macro runs once for each record (or a selected group of records) in the data. Inputs can be configured to be used in each run of the workflow or only in specific runs.

An Iterative Macro: will run through every record and then loop the records back through the workflow, repeating the entire process as many times as is specified, or until a condition is met. Iterative macro properties will only display on the Test tab in the Interface designer.

We can find the Macro input tool in the interface category:

We can also right click on our regular Workflow input tool

This is it for now. Catch you next week with a Standard Macro exercise.

Keep up the good work!

Peter Hajnal  DS|33