In some cases, multiple transformations are needed to transform the source data into the desired format. detamoov offers the ability to build a transformation definition from an already existing transformation definition, effectively chaining together multiple transformations into a single moov.
Initially, a transformation definition is created using a file definition - which is the definition of the source data detamoov receives that kicks off a specific moov. However, say you need to transform the source data and then transform the data again. detamoov allows multiple transformations on a single moov by using the output data from one transformation as the input definition of another transformation.
In our example below, we will be creating a multi-transformation moov definition based on a 360 integration where detamoov receives a scheduled deduction feedback file from Voya, transforms it to our Standard Deduction Feedback format, and then transforms that to a UKG Scheduled Deduction format.
Create a Transformation from a File Definition
Our first transformation definition will be based on the scheduled deduction feedback file from Voya. Here is a sample of the data that would come from Voya:
A file definition is created from this feedback file. For more information on creating a file definition, see the How to create a new file definition article.
To create a Transformation Definition, click on your initials in the upper right and select Admin Console. From there, click on the Transformation Definitions tab and click the 'Add' button.
Enter in a Name and Description, select File Definition as the Definition Type, and select the Voya Feedback File as the Input Definition. Then select CSV as the Output File Type and select a comma as the Delimiter.
We now want to be able to take the Voya deduction file, transform it to the Standard Deduction format, and then to the UKG scheduled format. Our next step would be to create the fields in the transformation to match the fields in the Standard Deduction format.
Here is an example of our Voya deduction file transformed to the Standard Deduction format:
We would create the fields in the transformation file to match those of the Standard Deduction Feedback format and Save the transformation.
Note: To continue with the next transformation you must first publish this transformation. To publish a definition, edit the definition and toggle the 'Published' switch in the upper right ON.
Creating a Transformation from a Transformation
detamoov has the ability to use the output data from one transformation as the input definition of another transformation. To accomplish this, we will create a new transformation definition. However, the main difference will be selecting Transformation Definition from the Input Definition Type and then selecting the previously created transformation as the Input Definition.
Now when we create fields for this transformation, the available fields will show as the fields created in the previous transformation.
This allows us to create a transformation to the UKG Scheduled Deduction format. Here is an example of that format:
Once all fields are created on the transformation matching the UKG Scheduled Deduction format. click Save Change and Publish the transformation.
Now that the transformations have been built to convert the Voya Deduction Feedback format to the UKG Scheduled Deduction format, we can put the all together in a moov Definition.
To create a moov Definition, click on the moov Definitions tab in the Admin Console and click the 'Add' button.
Then enter in a moov name, Integration Type, Integration With value and moov description.
Then click the 'Add Step' button and select 'Data Trigger' from the Step dropdown menu. Enter in a Description and select the File Definition created for the source file (the Voya Feedback file in our example), then click OK.
Click the 'Add Step' button again and select 'File Transformation' from the Step dropdown menu. Enter in a Description and select the Transformation Definition created to transform the Voya Deduction file to the Standard Deduction format, then click OK.
Then click the 'Add Step' button and select 'File Transformation' from the Step dropdown menu again. Enter in a Description and select the second Transformation Definition created to transform the Standard Deduction format to the UKG Scheduled Deduction format, then click OK.
We can then add additional steps to name the file, send the file via SFTP (or import using the UKG Retirement 360 step). This showcases the versatility of detamoov and the ability to create multiple transformations on a single moov definition.
