Transforming Data

To view your list of transforms:
  1. Do one of the following:
    • From the
      Open
      Dataset
       icon’s drop-down menu, select
      Transforms…
    • Click [Transforms].
  2. Select your dataset and click [OK]. Please note that you may work with more than one dataset simultaneously.
    The
    Transform
    Editor
     displays your transforms at the bottom of the dialog
    Transform Editor
  3. To manage your transforms, right-click on the transform and select one of the following:
    • Insert
      Before
      : inserts a new transform before the selected transform. Enter the variables and expression for the new transform and click [Insert].
    • Insert
      After
      : inserts a new transform after the selected transform. Enter the variables and expression for the new transform and click [Insert].
    • Edit
      : allows you to edit the selected transform. Make your changes in the
      Variables
       and
      Expression
       sections and click [Modify.]
      TIP:
      You can also select a transform for editing by double-clicking on it. This will populate the
      Variables
       and
      Expression
       sections with the transform’s configuration.
    • Delete
      : deletes the transform. This rolls back any actions performed on the data.
    • Copy
      : copies the selected transform’s text.
    • Paste
      : pastes the copied transform's text. After this, you may edit that duplicate transform
  4. After inserting, editing, or deleting, [Commit] or [Rollback] to execute the modified transform list. If any of the changes violate the rules described in“Transform Order”, the commit will fail.
  5. To add a new transform, perform the following steps.
    1. In the
      Variables
       box, either enter a variable name manually or type an exclamation mark (!), which is the character used to delimit variable names(see “General Transform Syntax” for more details). This opens a variable selection list from which you can filter from the first character. Select a variable by double-clicking it
      Add a Variable
    2. In the
      Expression
       box, enter an expression manually or type an exclamation mark (!) to open a drop-down menu of variables that can be selected to create your expression or the dollar sign ($) to open a drop-down menu of functions to apply.
      Add an Expression
      For additional assistance creating expressions, click [Content Assistant] in the upper right corner. A keypad and common transforms are displayed. You will see a broad range of functions available under an array of categories (Common, Math, String, etc.). In the
      Expression
       box, type a dollar sign ($) to open a drop-down menu of functions and constants to select from. Please note that If/And/Or/Not statements (e.g., nested If statements) can also be created. Search filters for variable names or transforms are available. Click
      Close
       at the bottom of the window. To close the assistance panel, click [Content Assistant] again.
      NOTE:
      The Variables search field is case-sensitive.
      See“General Transform Syntax” for more information on transform syntax.
      Content Assistant
    3. Click [Add] to add the new transform. It will be added to the transform list automatically in the correct sequence.
    4. To edit the new transform, double-click it in the transform list to have its variable and expression populate the
      Variables
       and
      Expression
       boxes.
    5. Edit the transform’s configuration as needed and click [Modify].
When you export part of the dataset for developing a Machine Learning (ML) application, you will want to execute these same transforms prior to scoring your ML algorithm.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.