Blocking Test
Tests an expression is true for all records in a data stream and if any are false does not pass any records downstream
Source: CReW Macros
Link: I:\CD Work\London\Data Analytics\Data repository\Alteryx\Alteryx macros\From web
Dynamic Formula
The Dynamic Formula Tool allows you to dynamically create formulas using a data feed. Effectively allowing you to write formulas by using other formulas, the summarize tool or other techniques. Great for when you need to write a long or complex formula or create a lot of formulas and don't want to do it manually.
Source: CReW Macros
Link: I:\CD Work\London\Data Analytics\Data repository\Alteryx\Alteryx macros\From web
Dynamic Metadata
Updates the metadata for a target data stream (T) based on a source data stream (S) similar to how the dynamic rename tool does renaming
Source: CReW Macros
Link: I:\CD Work\London\Data Analytics\Data repository\Alteryx\Alteryx macros\From web
Ensure Fields
Ensures that fields are present on a data stream. If the fields are already present it does not modify them, but if they are missing they will be appended to the data stream with all NULL values. There should be very little overhead from this macro, even for large streams of data.
Source: CReW Macros
Link: I:\CD Work\London\Data Analytics\Data repository\Alteryx\Alteryx macros\From web
Label Block Until Done
Stops downstream processing until the very last record has arrived. On output, it writes all records first to output1 before then starting writing all records to output2.
Source: CReW Macros
Link: I:\CD Work\London\Data Analytics\Data repository\Alteryx\Alteryx macros\From web
Parallel Block Until Done
Writes all input records from Input1 to Output1 and all input records from Input2 to Output2.
As with the standard block until done tool it stops downstream processing until the very last record has arrived for each input/output pair. Further it writes all records first to output1 before then starting writing all records to output2.
Source: CReW Macros
Link: I:\CD Work\London\Data Analytics\Data repository\Alteryx\Alteryx macros\From web
Version
Checks a module's/macro's version number against a number stored an external website and throws an error if there is a newer version available.
Source: CReW Macros
Link: I:\CD Work\London\Data Analytics\Data repository\Alteryx\Alteryx macros\From web
Wait A Second
This macro will wait x seconds between each record it processes.
Source: CReW Macros
Link: I:\CD Work\London\Data Analytics\Data repository\Alteryx\Alteryx macros\From web