Administration Guide › How to Perform Data Transformations › Define and Send Escalation Emails › Create and Apply Data Transformations › Capture Last Valid Date and Compare to End Date

Capture Last Valid Date and Compare to End Date

To identify expired role memberships, add a field to define the last valid date when you run the transformation. The transformation filter compares this last valid date to the role membership end date to filter out users with expired role memberships.

Follow these steps:

1. In PDI, in the Design tab, locate and expand the Transform step, select Add constant, and drag it to the Transformation screen.
2. Right-click the Add constants step and select Edit step.
3. Add a field that is 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. Click the Transform tab, 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 the Set field value to a constant step and select Edit step.

   The Set field value to a constant window opens.

8. Select the Use variable in constant option, and click Get fields.
9. Add the LastValidDate field and set the Replace by value field as follows:

   $[Latest_Valid_Date}
   

   You provide this date when you run the transformation.

10. Click Ok.

    You have added a field to define the last valid date when you run the transformation.