Topic outline

• Advanced Data Transformations

  Advanced Data Transformations

  Content Type
  Course

  Duration
  2h

  Level
  Intermediate

  Explore advanced features of the DTL Editor in the Management Portal such as code actions, utility functions, lookup tables, and subtransformations; and learn how to build them into the logic of your data transformations. By the end of this course, you will understand how to create and troubleshoot advanced data transformations.

  Data transformations are a powerful integration tool that allows you to manipulate data to meet the exact specifications and requirements of downstream systems. In this course, you will learn how to use several features available in the DTL Editor to create complex transformations, as well as options for troubleshooting a data transformation. You will try these features in a learning lab environment.

  Learning Objectives

  Within an existing data transformation:

  • Add a for each loop.
    
  • Create and use utility functions.
    
  • Create and use lookup tables.
    
  • Use counting.
    
  • Create and implement a subtransformation.
    
  • Add a code action.
    
  • Add a group of actions to organize relevant actions.

  Prerequisites

  • Basic knowledge of creating data transformations
• Start the Course

  Start the Course

  You must be logged in to view this content.

  Don't have an InterSystems account? Create a new account.
• What's Next?

  What's Next?

  In this course, you learned about several features available with data transformations: utility functions, for each actions, subtransformations, lookup tables, counting elements, code actions, and groups of actions. You also learned how to troubleshoot a transformation using the DTL test utility and settings related to error reporting. These features allow you to create complex data transformations within your integrations to make sure your data matches the exact specifications needed by downstream systems.

  Continue learning with the following resources:

  • Learn how to avoid truncation in HL7 messages with very large fields (32K+ characters) (article, 3m).
  • Read more about adding other actions to a DTL transformation (documentation, 20m).
  • See what utility functions are available (documentation).
  • See how adding a switch action can bring decision-making logic to your data transformation (video, 2m).

  • Share Your Feedback!