Adding fields

You can add new fields using Data transformations. Any additional field that is added to the SQL transformations of the output tables will show up in the app.

Prerequisites

• Make sure the inout data needed for your new field is available in your app. See Loading data.

• Make sure your data model adheres the requirements. See Data model requirements.

• Make sure the new field is defined in table SQL file in the models -> 1_input section of the Transformations for which you want to add a field. See also Adding new input tables.

Special characters in field names

More special characters are allowed in your names. You can define field names in data transformations with, for example, Japanese characters. These fields will be loaded in the data model and can be used in dashboards.

There is a small set of characters that are not allowed:

]	square bracket close
"	double quotes
,	comma
;	semicolon
{}	curly braces
\n	new line
\t	tab
=	equals
	blank space

Creating a new output field

Follow these steps to create a new output field using Data transformations.

1. Go to the Data transformations editor.

2. Select the applicable output table SQL file of the Transformations for which you want to define an output field.

3. Add the field in the select statement.

   

4. Select Apply to dashboards and run the transformations to make the field available for use in dashboards.

   Note:

   This may take several minutes. Only if the run finishes successfully, the new field will show up in the Data Manager.

5. Select Edit dashboards and open the Data Manager.

6. A message is displayed to inform you that new fields have been added. Select Confirm to continue.

   

7. Locate the new field and check the Source field and the Type for the new field.

The new field is marked with a blue dot.

The new field is now available for use in dashboard charts.

Note:

Once the process app is published with the new field, the blue dot is no longer displayed.