Solutions
...
Wizards and other Actions
Transformations Wizard
12 min
create and import models docid\ zpadx1lmme0f44v7r6v6q allow to transform the data collected in instances by converting raw json data to a desired format by defining the json based schema to assist with the definition of the transformations and ensure that the json object is correctly formatted, the dt model management tool provides a transformation wizard access the transformation wizard notes to access the transformation wizard it is required that a model type is selected a model name is defined select the respective cell in column transformations for the model you want to define transformation if all conditions are met, the transformation wizard button is shown in the help section of the litmusconfiguration ribbon open the transformation wizard by pressing the transformation wizard button the transformation wizard will show notes if the model has already transformations defined, they will be shown in the list add a new transformation schema to add a new transformation schema, press the add option from the left panel transformation schema are a set of three parameters name the name of the transformation schema schema type the format used by the transformation schema schema the transformation schema code to accept the entry press the green modify button notes if not all parameters for the transformation schema are provided, the modify button will remain grayed out and the transfromation schema can not be saved the wizard also performs a verification for each entry and will show any violation in red in this case the modify button will also be grayed out to prevent the saving of any invalid transformation schema notes the tool will also verify that the schema is correctly formated if the schema doesn't parse the modify button will remain grayed out notes optionally you can use system variables to define the schema code edit a transformation schema select the transformation schema you want to edit to open its edit screen edit any of the transformation schema parameters name the name of the transformation schema schema type the format used by the transformation schema schema the transformation schema code and press the modify button notes if not all parameters for the transformation schema are provided, the modify button will remain grayed out and the transfromation schema can not be saved the wizard also performs a verification for each entry and will show any violation in red in this case the modify button will also be grayed out to prevent the saving of any invalid transformation schema delete a transformation schema select the transformation schema you want to delete to open its edit screen to delete the transformation schema press the delete button save the transformations to save all the defined transformation schemas as a new transformations json object, press the save button this will create the correctly formatted transformations json object and store it in column transformations for the model important this will overwrite the current value in column transformations cancel the transformation wizard if a user decides to not save the current transformation wizard configuration, they can press the cancel button notes this will not overwrite the current value in column meta data