Programming Guide › Transforming Data › Create a Transformation › Add a Field to Define the Last Valid Date

Add a Field to Define the Last Valid Date

To identify if the role membership expired, add a field to define the last valid date when running the transformation. The transformation filter uses this last valid date to compare to the end date of the role membership.

Follow these steps:

1. Under Transform, select the Add Constants step and drag it to the Transformation screen.
2. Right click on the step and select Edit step.
3. Add the field named 'LastValidDate' of type 'String', and click Ok.
4. Create a hop between the Get User-Resource Links by Users step and the Add Constants step.
5. Under Transform, select the Set Field Value to a Constant step and drag it to the Transformation screen.
6. Create a hop between the Add Constants step and the Set Field Value to a Constant step.
7. Right click on the step and select Edit step.
8. Check the Use variable in constant check box.
9. Click Get Fields.
10. Add the LastValidDate field and set the Replace by Value field as follows:

    $[Latest_Valid_Date}
    

    You can provide this date when running the transformation.

11. Click Ok.