Modifiers | Data Tables | Twikit Academy

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	Description	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.
Not Filter	Inverts a filter condition by returning all rows that do not match the provided filter criteria. This node is typically used to exclude a subset of data by applying an existing filter and then negating its result.	Inputs Data Table: The source data table to filter. Filter: The filter condition to invert. Enabled: Toggles whether the node is active. Outputs Data Table: Filtered data table . Filter: The resulting filter.
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.

Modifier

Description

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.

Not Filter

Inverts a filter condition by returning all rows that do not match the provided filter criteria.

This node is typically used to exclude a subset of data by applying an existing filter and then negating its result.

Inputs

Data Table: The source data table to filter.
Filter: The filter condition to invert.
Enabled: Toggles whether the node is active.

Outputs

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

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.