Data load editor
Create and run data load scripts from the data load editor, and create connections to data sources. When you have loaded the data it is available to the app for analysis.
Click Data load editor in the app navigation menu to open the data load editor.
Scripts can also be generated when you load data using the data manager. However, if you need to use complex script statements, you need to create the script manually in the data load editor.
See: Loading and transforming data with scripting
Adding data from existing datasets
Click Add from data catalog. to open the data catalog. You can add data from multiple datasets.
Creating connections
Expand the Data sources panel to view Data connections. Click Create new connection add a connection to your script.
Creating and editing scripts
Write your script code in the script editor. Each script line is numbered and the script is color coded by syntax components.
UI item | Description |
---|---|
Search and replace text in the script. |
|
Comment/uncomment. | |
Indent code. | |
Outdent code. | |
Activate syntax help mode. In help mode you can click on a syntax keyword (marked in blue) in the editor to access detailed syntax help. |
|
Autocomplete script hints turned on. Click to turn off. | |
Autocomplete script hints turned off. Click to turn on. | |
Undo the latest change (multiple step undo is possible). | |
Redo the latest undo. |
Click to add a script section. The sections are executed from top to bottom.
Click to debug the script.
Click History to manage script versions.
See:
Running scripts
Click the Load data button to run the script. A dialog opens to display the progress of the data load and any messages that are generated. Additionally, you can click the Output button to view the output.
Running load scripts to load data in apps
You can also preview the load script. Previewing runs the load script while limiting the number of rows of source data loaded into the app and skipping any Store statements. You can set how many rows to include. To preview your data, click Preview data.
Previewing data in load scripts
Previewed or loaded data can be viewed by clicking the Preview button.