system.dataset.toDataSet
This function is used in Python Scripting.
Description
This function is used to
- Convert PyDataSets to DataSets
- Create new datasets from raw Python lists. When creating a new dataset, headers should have unique names.
Client Permission Restrictions
This scripting function has no Client Permission restrictions.
Syntax (Without Headers)
system.dataset.toDataSet(dataset)
Parameters
| Type | Parameter | Description |
|---|---|---|
| PyDataSet | dataset | A PyDataSet object to convert. |
Returns
Dataset - The newly created dataset.
Scope
All
Syntax (With Headers)
system.dataset.toDataSet(headers, data)
Parameters
| Type | Parameter | Description |
|---|---|---|
| PySequence | headers | A PyDataSet object to convert. |
| PySequence | data | A list of rows for the new dataset. Each row must have the same length as the headers list, and each value in a column must be the same type. |
Returns
Dataset - The newly created dataset.
Scope
All
Code Examples
Example 1
# This example create a single column dataset.
header = ['myColumn']
rows = [[1], [2]]
dataset = system.dataset.toDataSet(header, rows)
Example 2
# This first example shows how this function can be used to convert from a PyDataSet (which is what system.db.runQuery returns) to a normal DataSet, which is the datatype of a Table component's data property.
pyDataSet = system.db.runQuery("SELECT * FROM example1 LIMIT 100")
table = event.source.parent.getComponent("Table")
normalDataSet = system.dataset.toDataSet(pyDataSet)
table.data = normalDataSet