Modifiers | Data Tables

Data Tables

Data Table modifiers allow you to work with CSV-based datasets inside the graph. They can be used to query, filter, join, and extract values from structured data, enabling configuration logic driven by external spreadsheets.

Data Tables are commonly used to populate option lists dynamically, map parameters to values, or implement pricing and lookup logic.

Modifier

Explanation

Input

And Filter

Combines multiple filters using a logical AND operation.

Inputs

Data Table: The source data table.
Filter 1–5: Filters to combine.
Enabled: Enables or disables the filter.

Outputs

Data Table: Filtered data table.
Filter: The combined filter.

Column Between Filter

Filters rows where a column value lies between two numeric bounds.

Inputs

Data Table: The source data table.
Column: Column to evaluate.
Lower / Upper: Lower and upper bound values.
Lower Inclusive / Upper Inclusive: Whether bounds are inclusive.
Enabled: Enables or disables the filter.

Outputs

Data Table: Filtered data table.
Filter: The resulting filter.

Count

Counts the number of rows in a data table.

Inputs

Data Table: The source data table.

Outputs

Count: Number of rows.

Distinct

Returns a data table containing only distinct values from a column.

Inputs

Data Table: The source data table.
Column: Column used to determine uniqueness.

Outputs

Data Table: Table containing distinct rows.

Get Number

Retrieves a numeric value from a specific row and column.

Inputs

Data Table: The source data table.
Row: Row index.
Column: Column name.
Default: Value returned if the cell is empty or invalid.

Outputs

Number: Retrieved numeric value.

Get Text

Retrieves a text value from a specific row and column.

Inputs

Data Table: The source data table.
Row: Row index.
Column: Column name.
Default: Value returned if the cell is empty or invalid.

Outputs

Text: Retrieved text value.

Join

Joins two data tables based on matching column values.

Inputs

Source Data Table: First data table.
Target Data Table: Second data table.
Source Join Column: Column used from the source table.
Target Join Column: Column used from the target table.
Result Source Columns: Columns to keep from the source table.
Result Target Columns: Columns to keep from the target table.

Outputs

Data Table: Joined data table.

Number Between Filter

Filters rows where a numeric value lies between values defined in two columns.

Inputs

Data Table: The source data table.
Value: Value to compare.
Lower Column / Upper Column: Columns defining bounds.
Lower Inclusive / Upper Inclusive: Whether bounds are inclusive.
Enabled: Enables or disables the filter.

Outputs

Data Table: Filtered data table.
Filter: The resulting filter.

Number Filter

Filters rows based on a numeric comparison.

Inputs

Data Table: The source data table.
Column: Column to evaluate.
Operation: Comparison operator (==, <, <=, >, >=).
Value: Value to compare against.
Enabled: Enables or disables the filter.

Outputs

Data Table: Filtered data table.
Filter: The resulting filter.

Or Filter

Combines multiple filters using a logical OR operation.

Inputs

Data Table: The source data table.
Filter 1–5: Filters to combine.
Enabled: Enables or disables the filter.

Outputs

Data Table: Filtered data table.
Filter: The combined filter.

Sort

Sorts a data table by a given column.

Inputs

Data Table: The source data table.
Column: Column used for sorting.
Sorting: Data type used for sorting (e.g. text or number).
Order: Ascending or descending.

Outputs

Data Table: Sorted data table.

String Filter

Filters rows based on string comparison.

Inputs

Data Table: The source data table.
Column: Column to evaluate.
Value: String to compare against.
Query: Comparison type (Equals, Not Equals, Contains, Not Contains, Starts With, Ends With).
Enabled: Enables or disables the filter.

Outputs

Data Table: Filtered data table.
Filter: The resulting filter.