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:
- Open Window > Preferences. Navigate the menus to Ataccama DQC > Expression Editor > Templates.
- Choose between Expression Templates and RegEx Templates, select a folder and click Add Template... In the following dialog window specify the Name, Expression 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.