Datatable in Expression Language - Revision history

Ollvihe: /* Datatable Properties */

2026-04-14T13:03:19Z

Datatable Properties

← Older revision		Revision as of 13:03, 14 April 2026
Line 131:		Line 131:
	\|\|NRows (Integer)		\|\|NRows (Integer)
	\|\|Number of data rows in the datatable.		\|\|Number of data rows in the datatable.
			\|-
			\|\|PrimaryKey (String*)
			\|\|Array of column names that belong to the datatable primary key.
	\|-		\|-
	\|\|Project (Project)		\|\|Project (Project)

Ollvihe: /* Datatable Functions */

2025-05-22T12:52:21Z

Datatable Functions

← Older revision		Revision as of 12:52, 22 May 2025
Line 388:		Line 388:
	</pre>		</pre>
	\|-		\|-
	\|\|SetForeignKeys		\|\|<span id="SetForeignKeys">SetForeignKeys</span>
	\|\|Foreign keys (Dictionary array)		\|\|Foreign keys (Dictionary array)
	\|\|Sets foreign keys for the datatable, i.e., certain column(s) in the datatable form a key that is referring to columns in another datatable.		\|\|Sets foreign keys for the datatable, i.e., certain column(s) in the datatable form a key that is referring to columns in another datatable.

Ollvihe: /* Datatable Functions */

2025-05-22T12:51:57Z

Datatable Functions

← Older revision		Revision as of 12:51, 22 May 2025
Line 390:		Line 390:
	\|\|SetForeignKeys		\|\|SetForeignKeys
	\|\|Foreign keys (Dictionary array)		\|\|Foreign keys (Dictionary array)
	\|\|Sets foreign keys for the datatable. ~~Foreign keys mean that~~ certain column(s) in the datatable ~~forms~~ a key that is referring to ~~other~~ datatable.		\|\|Sets foreign keys for the datatable, i.e., certain column(s) in the datatable form a key that is referring to columns in another datatable.

	The function call replaces previously defined foreign keys, so all foreign keys of the datatable need to be mentioned in the call. The parameter has the same structure as in the '''ForeignKeys''' property (see above). Providing an empty array removes all foreign keys. Note that the column(s) and target datatable(s) mentioned in the foreign keys don't actually need to exist.		The function call replaces previously defined foreign keys, so all foreign keys of the datatable need to be mentioned in the call. The parameter has the same structure as in the '''ForeignKeys''' property (see above). Providing an empty array removes all foreign keys. Note that the column(s) and target datatable(s) mentioned in the foreign keys are not validated when set, so they don't actually need to exist.

	Examples:		Examples:

Ollvihe: /* Datatable Properties */

2025-03-04T23:55:35Z

Datatable Properties

← Older revision		Revision as of 23:55, 4 March 2025
Line 73:		Line 73:
	* '''SqlServer''': data is stored to an SQL Server database (defined by the [[PA_Configuration_database_table#General_Settings\|SqlServerConnectionString]] setting).		* '''SqlServer''': data is stored to an SQL Server database (defined by the [[PA_Configuration_database_table#General_Settings\|SqlServerConnectionString]] setting).
	* '''Snowflake''': data is stored to Snowflake.		* '''Snowflake''': data is stored to Snowflake.
	* '''Spark''': data is stored to Databricks.
	* '''Redshift''': data is stored to AWS Redshift.
	\|-		\|-
	\|\|Description (String)		\|\|Description (String)

Ollvihe: /* Datatable Properties */

2024-08-06T11:34:04Z

Datatable Properties

← Older revision		Revision as of 11:34, 6 August 2024
Line 145:		Line 145:
	\|\|SqlDataFrame (SqlDataFrame)		\|\|SqlDataFrame (SqlDataFrame)
	\|\|Returns [[SqlDataFrame_in_Expression_Language\|SqlDataFrame]] that can be used to access the contents of the DataTable.		\|\|Returns [[SqlDataFrame_in_Expression_Language\|SqlDataFrame]] that can be used to access the contents of the DataTable.
			\|-
			\|\|UsedInModels (Model*)
			\|\|Returns list of all models which are using this datatable as a datasource.
	\|}		\|}

Ollvihe: /* Datatable Properties */

2024-05-16T20:21:54Z

Datatable Properties

← Older revision		Revision as of 20:21, 16 May 2024
Line 60:		Line 60:
	\|\|DataFrame (DataFrame)		\|\|DataFrame (DataFrame)
	\|\|Contents of the datatable as a [[#DataFrame\|DataFrame]].		\|\|Contents of the datatable as a [[#DataFrame\|DataFrame]].
			\|-
			\|\|DataSourceConnection
			\|\|Returns the connection object used by this datatable to connect to its datasource.
	\|-		\|-
	\|\|DataSourceObjectType (String)		\|\|DataSourceObjectType (String)

Ollvihe: /* Datatable Functions */

2024-01-10T11:11:59Z

Datatable Functions

← Older revision		Revision as of 11:11, 10 January 2024
Line 199:		Line 199:
	\|\|<span id="DeleteRows">DeleteRows</span>		\|\|<span id="DeleteRows">DeleteRows</span>
	\|\|Expression to select deleted rows		\|\|Expression to select deleted rows
	\|\|Deletes ~~selected~~ rows from datatable. The parameter is an expression (evaluated for each row) to select which rows are deleted. If the parameter is not specified, all rows are deleted.		\|\|Deletes defined rows from the datatable. The parameter is an expression (evaluated for each row) to select which rows are deleted. If the parameter is not specified, all rows are deleted.

	Example: Delete ~~all~~ rows from model's events datatable where Organization column value is Finance:		Example: Delete rows from model's events datatable where Organization column value is Finance:
	<pre>		<pre>
	ModelById(1)		ModelById(1)
Line 208:		Line 208:
	</pre>		</pre>

	Example: Delete ~~all~~ rows where Revenue column has lower value than Cost column:		Example: Delete rows where Revenue column has lower value than Cost column:
	<pre>		<pre>
	DatatableById(1)		DatatableById(1)
Line 214:		Line 214:
	</pre>		</pre>

	Example: Delete ~~all~~ rows where PredictedEvent column value is true:		Example: Delete rows where PredictedEvent column value is true:
	<pre>		<pre>
	DatatableById(1)		DatatableById(1)

Ollvihe at 11:11, 10 January 2024

2024-01-10T11:11:05Z

← Older revision		Revision as of 11:11, 10 January 2024
Line 197:		Line 197:
	</pre>		</pre>
	\|-		\|-
	\|\|DeleteRows		\|\|<span id="DeleteRows">DeleteRows</span>
	\|\|Expression to select deleted rows		\|\|Expression to select deleted rows
	\|\|Deletes selected rows from datatable. The parameter is an expression (evaluated for each row) to select which rows are deleted. If the parameter is not specified, all rows are deleted.		\|\|Deletes selected rows from datatable. The parameter is an expression (evaluated for each row) to select which rows are deleted. If the parameter is not specified, all rows are deleted.

Ollvihe: /* Datatable Functions */

2024-01-08T15:29:32Z

Datatable Functions

← Older revision		Revision as of 15:29, 8 January 2024
Line 199:		Line 199:
	\|\|DeleteRows		\|\|DeleteRows
	\|\|Expression to select deleted rows		\|\|Expression to select deleted rows
	\|\|Deletes rows from ~~the~~ datatable. The parameter is an expression to select which rows are deleted. If the parameter is not specified, all rows are deleted.		\|\|Deletes selected rows from datatable. The parameter is an expression (evaluated for each row) to select which rows are deleted. If the parameter is not specified, all rows are deleted.

	Example: Delete all rows from model's events datatable where Organization column value is Finance:		Example: Delete all rows from model's events datatable where Organization column value is Finance:

Ollvihe: /* Datatable Functions */

2024-01-08T15:27:58Z

Datatable Functions

← Older revision		Revision as of 15:27, 8 January 2024
Line 205:		Line 205:
	ModelById(1)		ModelById(1)
	.EventsDataTable		.EventsDataTable
	.DeleteRows(Column("Organization") == "Finance")		.DeleteRows(Column("Organization") == "Finance");
	</pre>		</pre>

Line 211:		Line 211:
	<pre>		<pre>
	DatatableById(1)		DatatableById(1)
	.DeleteRows(Column("Revenue") < Column("Cost"))		.DeleteRows(Column("Revenue") < Column("Cost"));
	</pre>		</pre>

Line 217:		Line 217:
	<pre>		<pre>
	DatatableById(1)		DatatableById(1)
	.DeleteRows(Column("PredictedEvent"))		.DeleteRows(Column("PredictedEvent"));
	</pre>		</pre>

	Example: Delete all rows from datatable:		Example: Delete all rows from datatable:
	<pre>		<pre>
	DatatableById(1).DeleteRows()		DatatableById(1).DeleteRows();
	</pre>		</pre>
	\|-		\|-

← Older revision		Revision as of 13:03, 14 April 2026
Line 131:		Line 131:
	\|\|NRows (Integer)		\|\|NRows (Integer)
	\|\|Number of data rows in the datatable.		\|\|Number of data rows in the datatable.
			\|-
			\|\|PrimaryKey (String*)
			\|\|Array of column names that belong to the datatable primary key.
	\|-		\|-
	\|\|Project (Project)		\|\|Project (Project)

← Older revision		Revision as of 20:21, 16 May 2024
Line 60:		Line 60:
	\|\|DataFrame (DataFrame)		\|\|DataFrame (DataFrame)
	\|\|Contents of the datatable as a [[#DataFrame\|DataFrame]].		\|\|Contents of the datatable as a [[#DataFrame\|DataFrame]].
			\|-
			\|\|DataSourceConnection
			\|\|Returns the connection object used by this datatable to connect to its datasource.
	\|-		\|-
	\|\|DataSourceObjectType (String)		\|\|DataSourceObjectType (String)