The Data Load Editor is where we:
- Connecting / Loading data sources
- Set variables for use within our script
- Variables used within our script also become available for use in our app, but they cannot be edited once they hit the app
- ETL style data modification
The more work we do within the Data Load Editor, the less work your Qlik app must do to process data on the fly. This is where you clean and organize your data. See Qlik Scripting for more information on how to write Qlik Scripts.
Sections
The Data Load Editor is broken down into Sections, the script iterates through these from a top-down perspective. Sections should be thought of as logical separations of code
Main
The Main section is generated upon app creation. All of the values within the main section can be modified and propagate throughout an app.
Possible edits that can be made within the Main script:
- Updating the Date or Time format
- Updating Short / Long month / date name formats
Debugging
It is possible to set breakpoints within the Data Load Editor and check values of variables. It is even possible to choose to have a limited load of data from each of your tables for testing purposes.