You use the Create JavaScript Table wizard to add a new
JavaScript Table and specify its structure.
About this task
To create a JavaScript Table:
Procedure
- Select . In the opened window select JavaScript
Tables and click Next.
The Create New JavaScript Table wizard
opens.
-
On the Add New JavaScript Table page, specify the name for the table you
create and select a JavaScript data source or a virtual data source where you want to save it. Click
Next.
Note: The Data Source list contains only virtual data sources from the
current repository connection.
- On the JavaScript Table Structure page,
define the table structure including the list of columns, their order,
value types and required parameters. You can also add comments to
any column.
-
Click Finish to close the wizard.
The JavaScript Table with the specified name and structure is added to the selected
JavaScript data source or virtual data source. After closing the wizard, JavaScript
Table editor opens.
- In the JavaScript Table editor,
you create scripts to populate the JavaScript Table with the required
data.
- When you finish working with script, save the changes and
close the editor.
Results
Now you can use the created JavaScript Table as a typical
relational table. For example, you can run queries based on the created
JavaScript Table, use them to create quick reports, forecasts, or
add to visual dashboards.