Set Project Variable Values from Table
Description
Section titled “Description”Reads values out of a project table and assigns them to project variables. Unlike Set Workflow Variable Values from Table, the values persist beyond the run — every workflow in the project sees them until something changes them again.
Use it for state that outlives a single run: the last period successfully loaded, a watermark timestamp, or a current-scenario name.
Configuration
Section titled “Configuration”Source Columns
Section titled “Source Columns”Map each source column to the project variable it populates. The step reads a single row, so narrow the table to one row before it runs.
Select Subset of Data
Section titled “Select Subset of Data”A filter expression that narrows the source rows.
Apply Secondary Filter to Result Data
Section titled “Apply Secondary Filter to Result Data”A HAVING-style filter applied after aggregation.
Final Data Table Slicing (Limit)
Section titled “Final Data Table Slicing (Limit)”Off by default, and limited to one row when on. Turn it on with an explicit ordering when the source could return several candidate rows.