How to Add Predefined Templates for Expressions

Reported for version 10

Every step that allows for the input of an expression shows a button called Template.... This includes the transformation step Column Assigner or business rules in the Profiling step. This button can be used to pre-fill the Expression field with one from an out-of-the-box list. You can create your own expressions for common or complex repeatable operations.

As seen above, the Template button opens a dialog with a list of out-of-the-box and user defined templates.

In order to add new templates to the list, follow these steps:

  1. Open Window > Preferences. Navigate the menus to Ataccama DQC > Expression Editor > Templates

  2. Choose between Expression Templates and RegEx Templates, select a folder and click Add Template... In the following dialog window specify the NameExpression itself and Description.

When opening the Templates section, you will see a complete list of all the Expression and RegEx Templates available. Besides inspecting the templates, you can edit, add, remove templates through their respective buttons, or organize the templates by a folder structure and the Move button. Moreover, the templates can be exported or imported in bulk through the Import... and Export... buttons.