Skip to main content

Using the 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 under the Prepare tab in the navigation bar to open the data load editor.

Data load editor
Storytelling view.

Toolbar

Toolbar with the most frequently used commands for the data load editor.

To learn more about the data load script, see Saving the load script, Debug the data load script and Run the script to load data.

Data connections

Under Data connections you can save shortcuts to the data sources (databases or remote files) you commonly use. This is also where you initiate selection of which data to load. Data connections are sorted by the spaces to which you have access.

For more information, see Loading analytics data and Select data in the data load editor.

Text editor

You can write and edit the script code in the text editor. Each script line is numbered and the script is color coded by syntax components. The text editor toolbar contains commands for Search and replace, Help mode, Undo, and Redo The initial script contains some pre-defined regional variable settings, for example SET ThousandSep=, that you can optionally edit. For more information, see Modifying app regional settings.

To learn more about script, see Edit the data load script and Script syntax overview.

Sections

Divide your script into sections to make it easier to read and maintain. The sections are executed from top to bottom.

If you have added data using Add data, you will have a data load script section named Auto-generated section that contains the script code required to load the data.

For more information, see Organizing the script code.

Output

Output displays the autosave status and all messages that are generated during script execution.

Quick start

If you want to load a file or tables from a database, complete the following steps in Data connections:

  1. Create new connection linking to the data source ( if the data connection does not already exist).
  2. Data Selection Select data from the connection.

Option Description

Global menu with navigation options, and actions that you can perform in your app.

For more information about tabbed browsing and the global menu, see Navigating using tabs.

Prepare

Prepare your data. You can select Data manager, Data model viewer, or Data load editor.

Analyze

Analyze your data in Sheet.

Narrate

Tell a story with your data. You can select Storytelling.

More

Show or hide app information, where you can choose to edit app information or open app options and style your app.
Debug

Debug the script.

For more information, see: Debug the data load script

Load data Load data

Run the script to load data. The app is automatically saved before reloading.

For more information, see: Run the script to load data

open right panel Toggle Data connections view.
Option Description
Search

Search and replace text in the script.

Comment / Uncomment Comment/uncomment.
Indent Indent.
Undent Outdent.
Help

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.

Note: It is not possible to edit the script in help mode.
Undo

Undo the latest change in the current section (multiple step undo is possible). This is equivalent to pressing Ctrl+Z.

Redo Redo the latest Undo in the current section. This is equivalent to pressing Ctrl+Y.