Configuration > Data Transformations

Intended audience: DATA SCIENTISTS DEVELOPERS ADMINISTRATORS

AO Platform: 4.3

Overview

The Data Transformations page allows additional transformation functions to be applied to the data retrieved from the data source (from the Training Data page). Such transformation functions can be applied per field property, and the user can select from a list of predefined transformations in the Transformation dropdown. The Data Preview section of the page will show the data, including the field properties that have received the Transformations. Those columns will be colored green to easily validate the transformed values.

Recommended Transformations

If the Training Data Source comes from an MSO instead of a Database or MSO Query, then the Data Transformation page will include an additional Show Recommendations button that, when clicked, will show a dialog with system-suggested Transformations to apply. Field properties that are shown will have one or more recommended Transformations shown. Select the Transformations to be added, then click the Add button, and the recommended Transformations will be inserted on the Data Transformations page.

The Data Transformations page, when a Database or MSO Query is selected as the Data Source on the Training Data page	The Data Transformation page, when MSO is selected as the Data Source on the Training Data page

Parameters

Each transformation function may optionally come with one or more parameters whose values must be updated by the user.

Custom Transformation

If a Transformation is required that is not part of the default list in the Transformation dropdown, simply select the Custom option, then click the “pencil” icon after the Transformation Function field to open a Python code dialog where a Custom Transformation Function can be entered. While adding the Python code, users can select to View the MSO field properties and/or View Errors that may arise. Click the Save button in the Python dialog to add.

Properties

Label	Description
Property	A dropdown allowing the user to select the individual data source properties that require a transformation to be applied. If multiple properties are added per Transformation, then the order of the Properties and their Data Types must be as required by the Transformation function.
Transformation	Dropdown that will show a list of available transformation functions. Transformation functions are added in Admin solution - see Admin > AI Configurations. For ad-hoc Custom Transformations, see the Custom Transformation section above.
Parameters	Click the Parameters icon to open a dialog with a list of parameters for the selected transformation. Most/all parameters will have a default value. Change if needed. Click Apply when done.
Custom Function	This property is only available when Custom is selected in the Transformation dropdown. For ad-hoc Custom Transformations, see the Custom Transformation section above.

Contact App Orchid | Disclaimer