ACAW flashcards
ACAW · Build recall with a focused review session.
32 cards. Read the term and the definition here. The deck at the top of this page is optional.
- Full Outer Join
- A join that returns all matched records plus unmatched records from both inputs, filling missing fields with nulls on each side.
- Union Auto by Name
- A union configuration that aligns fields by name across inputs; fields absent from an input are filled with nulls in the combined output.
- Append Fields tool
- Produces a Cartesian product of every row in the source with every row in the target, creating the cross join used for constant lookups.
- Cross-tab tool
- Pivots rows to columns using a header field for new column names, a data field for values, and an aggregation method such as Sum or Count.
- Block Until Done
- A tool that enforces sequential execution of its numbered output anchors, ensuring an upstream write completes before downstream tools read the file.
- Cache and Run Workflow
- A per-tool option that stores output so downstream tools skip re-execution until the tool's configuration or upstream data changes.
- Detour and Detour End
- A paired tool set that routes records around a section based on a control parameter; Detour End marks where the bypassed and normal paths merge.
- Tool container
- A grouping element that holds multiple tools and can be enabled or disabled as a unit, preventing execution of contained tools when disabled.
- IIF function
- A two-branch conditional function returning one of two values based on a boolean test; both branch expressions are evaluated before selection.
- Coalesce function
- Returns the first non-null value among its arguments, commonly used to fill nulls from a prioritized list of fallback fields.
- REGEX_Match return values
- Returns -1 when no match is found, 0 when the pattern matches without a capture group, or the number of the matched capture group.
- DateTimeDiff function
- Returns an integer difference between two date-time values in a specified unit such as days, months, or seconds.
- Spatial Match tool
- Joins two spatial streams based on a spatial predicate such as Intersects, Contains, or Within rather than on a shared key field.
- Trade Area tool
- Generates polygons around spatial points using a radial distance or drive-time method, used for market and catchment analysis.
- Score tool
- Applies a trained model object to new records to produce predicted values or probabilities, and outputs a report of model performance.
- Create Samples tool
- Splits input records into estimation and validation samples using random or systematic selection, supporting model training and out-of-sample testing.
- Regex Parse mode
- Extracts one output field per capture group in the regular expression, producing new fields from matched portions of the input string.
- Text to Columns tool
- Splits a single field into multiple fields or rows using a delimiter or fixed width, optionally retaining the original unsplit field.
- Dynamic Rename tool
- Renames fields at runtime using the first row of data as headers or a formula, allowing schema changes without manual reconfiguration.
- JSON Parse tool
- Takes a field containing JSON text and flattens its nested structure into individual output fields for downstream processing.
- Batch macro
- A macro that iterates over grouped records, using a Control Parameter to drive the loop and update configuration on each iteration.
- Iterative macro
- A macro that loops repeatedly until a stopping condition is met, requiring a loop-back connection and a conditional exit.
- Control Parameter tool
- A macro interface tool that receives a value or field from the calling workflow and drives batch macro iteration or configuration updates.
- Action tool
- An interface tool that updates a downstream tool's configuration, such as a value, field selection, or raw XML, based on user input.
- Analytic App file type
- A workflow with an Interface layer saved as .yxwz, which prompts users for values and runs with those inputs supplied.
- Condition tool
- An interface tool that shows or hides downstream questions based on a boolean result, enabling dynamic app branching.
- Chained Apps
- Multiple analytic apps run in sequence, passing values from one app to the next through output options or shared files.
- Error Message tool
- Halts an analytic app or workflow and displays a custom message when a specified validation condition evaluates to true.
- Message tool severity
- Configures the log level as Error (stops the workflow), Warning, or Info (logs without halting), used for data-quality gates.
- Early Select for performance
- Placing a Select tool early drops unused fields before joins, sorts, and spatial operations, reducing memory and improving execution speed.
- Parse Error cause
- Occurs when a formula expression is malformed, such as mismatched parentheses, missing ENDIF, or an invalid function argument count.
- Field not found error
- Occurs when a downstream tool references a field that was renamed, dropped, or never produced upstream, breaking the expression or configuration.