Workflow Logic, Macros, and Reusability
Conditional Logic
Formula and Filter handle row-level logic; the Dynamic Rename and Dynamic Select tools change schema at run time. The Test tool validates assumptions (for example, no nulls in a key) and can stop a workflow on failure - useful for data-quality gates.
Macros
Three macro types: Standard (a tool with input/output anchors), Batch (runs once per group of records, driven by a control parameter), and Iterative (loops until a condition is met). Macros are saved as .yxmc files and added to the palette. A macro's interface is defined by its input and output anchors plus any control parameters. Traps: a Batch macro needs a control parameter to drive iterations; a Standard macro does not loop.
Apps and Interface Tools
Analytic Apps use interface tools (Text Box, Drop Down, File Browse) to feed values into tools via Action tools. The Question anchor connects interface elements to the Action that updates a configuration. Apps are .yxwz files.
Reusability
Macros let you package logic once and reuse it; they also isolate complexity. Nesting macros is allowed but complicates debugging.
Worked example: To run the same cleansing on 12 monthly files, use a Batch macro with a control parameter feeding the file path. Rule of thumb: one run → Standard; one run per group → Batch; repeat until done → Iterative.