# Set a variable from data

Control / params

A variant of [Set parameters](https://meridian.online/operations/set-parameters).

Take a value computed from a table or query, such as a cell, a row or a count, and hold it as a variable.

Page: <https://meridian.online/operations/set-parameters/set-a-variable-from-data>

## Status

Not built yet.

arcform does not do this yet; it would live in how a Protocol runs. [Its place on the roadmap](https://meridian.online/roadmap#set-parameters)

## What other tools call it

Meridian's classification; an independent blind rating agreed on 95.7% of 324 rows (variant, version 3).

- dbt-utils: [`get_query_results_as_dict`](https://raw.githubusercontent.com/dbt-labs/dbt-utils/main/README.md) (read 2026-09-27)
- dbt-utils: [`get_single_value`](https://raw.githubusercontent.com/dbt-labs/dbt-utils/main/README.md) (read 2026-09-27)
- Duckle: [`Set Run Variable`](https://github.com/slothflowlabs/duckle/blob/f85f8960edfb6efbf4cb89d58a7b32e16df0e867/frontend/src/workflow-ui/palette-data.ts) (read 2026-09-25)
- Apache Hop: [`Set Variables`](https://hop.apache.org/manual/latest/pipeline/transforms/setvariable.html) (read 2026-09-27)
- KNIME Analytics Platform: [`Table Column to Variable`](https://api.hub.knime.com/nodes/*l-X3DwF-6CI27P9l?details=full) (read 2026-09-27)
- KNIME Analytics Platform: [`Table Row to Variable`](https://api.hub.knime.com/nodes/*fI6e-FYDCsugy9m_?details=full) (read 2026-09-27)
- Pentaho Data Integration: [`Set Variables`](https://docs.pentaho.com/pdia-data-integration/9.3-data-integration/pdi-transformation-steps-reference-overview) (read 2026-09-27)
- RapidMiner Studio: [`Extract Last Modifying Operator`](https://docs.rapidminer.com/latest/studio/operators/extensions/Operator%20Toolbox/macros/get_source_of_object_as_macro.html) (read 2026-09-27)
- RapidMiner Studio: [`Extract Macro`](https://docs.rapidminer.com/latest/studio/operators/utility/macros/extract_macro.html) (read 2026-09-27)
- RapidMiner Studio: [`Extract Macro (Format)`](https://docs.rapidminer.com/latest/studio/operators/extensions/Operator%20Toolbox/macros/extract_macro_enhanced.html) (read 2026-09-27)
- RapidMiner Studio: [`Extract Macro from Annotation`](https://docs.rapidminer.com/latest/studio/operators/utility/annotations/extract_macro_from_annotation.html) (read 2026-09-27)
- RapidMiner Studio: [`Set Macros from ExampleSet`](https://docs.rapidminer.com/latest/studio/operators/extensions/Operator%20Toolbox/macros/set_macros_from_exampleset.html) (read 2026-09-27)
- SQLMesh: [`@EVAL`](https://github.com/SQLMesh/sqlmesh/blob/23b237cea7218cc8f338b89c14f0957394a0003b/docs/concepts/macros/sqlmesh_macros.md) (read 2026-09-27)
- Talend: [`tContextLoad`](https://help.qlik.com/talend/en-US/components/8.0/context/context-component) (read 2026-09-27)