system.dataset.addRows

This function is used in Python Scripting.

Description

Takes a dataset and returns a new dataset with new rows added or inserted into it. If the rowIndex argument is omitted, the rows will be appended to the end of the dataset.

note

Datasets are immutable, which means they cannot be directly modified once created. Instead, this scripting function returns a new dataset with some modification applied, which must be assigned to a variable to be used. See Altering a Dataset.

Client Permission Restrictions

This scripting function has no Client Permission restrictions.

Syntax

system.dataset.addRows(dataset, [rowIndex], rows)

Parameters

Type	Parameter	Description
Dataset	dataset	The starting dataset. Please be aware that this dataset will not actually be modified (datasets are immutable), but rather will be the starting point for creating a new dataset.
Integer	rowIndex	The index (starting at 0) at which to insert the new row. Will throw an IndexError if less than zero or greater than the length of the dataset. If omitted, the new row will be appended to the end. [optional]
List[Any]	rows	A Python sequence of sequences representing the data for the new rows. The length of each sequence must equal the number of columns in the dataset.

Returns

Dataset - A new dataset with the new rows inserted or appended.

Scope

Gateway, Vision Client, Perspective Session

Code Examples

Code Snippet

# This example adds new options to a Vision Dropdown List by adding a row to its underlying dataset.
# Note that the last line assigns the return value of the addRows function to the dropdown's data property.
 
dropdown = event.source.parent.getComponent("Dropdown")
newRow = [[5, "New Option"], [6, "Another New Option"]]
dropdown.data = system.dataset.addRows(dropdown.data, newRow)

Code Snippet

# This snippet adds new options into a Dropdown component just like above, but at the beginning:
 
dropdown = event.source.parent.getComponent("Dropdown")
newRow = [[5, "New Option"], [6, "Another New Option"]]
dropdown.data = system.dataset.addRows(dropdown.data, 0, newRow)