A number of the following articles will cover the syntax of statements when using the data load editor.
The syntax varies depending on the statement required. You will need to use your judgement on what transformations are required to achieve your desired results and thus what statements should be used. This will become much easier with practice.
Statements can be of a ‘regular‘ or ‘control‘ type. A control statement is used to control the flow of the execution. A regular statement is used to load and transform the data. Within regular statements, script functions are used to achieve the required data transformations and aggregations when loading data to be used in app visualisations.
Regular statements can span across many lines and must be ended with a ‘;’. Prefixes can be used with these types of statements.
Control statements are kept on a single line and can be ended by using a ‘;’ or just at the end of the line.
Note that field names and variables used in the script are case-sensitive.
