Exercise: Add Field Transformations ProductModel, ProductCategory, and ProductSubCategory

Fields transformations let you modify existing data in a number of ways. For example, you can easily reverse the sign of numeric values, trim fields or return a specified number of characters from the original field value. For more detailed information, please see Selecting, Validating and Transforming Data.


  1. Expand the Product table in the DSA Data Warehouse
  2. Right click the ProductModelName field and select Field Transformations
  3. Select Fixed value in the Operator drop-down list
  4. Type "None" in the Value box and click Add button
  5. Right click the Transformation "Fixed Value 'None'" and select Add Condition
  6. Select the ProductModelName field in the Conditions pane
  7. Leave the value "Is empty" in the Operator drop-down list and click Add button
  8. Repeat steps 2 through 7 for ProductCategoryName field and ProductSubCategoryName field.
  9. Deploy and Execute the Product table
  10. Validate the result using Preview and Query Tool

Have Questions?

  1. Search for key words in the Support Portal to find topics that may already have answers.
  2. Can find the answer to your question? Post your question in the TimeXtender community forum!
    1. Write your question in the box and select the appropriate topic.