New post

#DTL

10

Ensemble supports Data Transformation Language (DTL) for describing data transformations. DTL is an XML language. Ensemble provides wizards and graphical tools for creating, editing, and testing DTL transformations. A data transformation is a Caché class like the following. If you prefer you can use Studio to edit the class definition directly and bypass the wizards and graphical tools.

Documentation.

The users wants the ability to modify the logic used to populate PID:22 depending on the value of PID: 39. The logic is as follows

If both PID:22 and PID:39.2 are null then set PID:28 to "Unknown"

If PID:22 and PID:39.2 are not null and are the same value, then populate PID:28 with PID:39.2

If PID:22 and PID:39.2 are not null and are different, then set PID:28 = "Undetermined"

Setting this condition in a transform is straight-forward,.

0 2
0 17