Administration Guide › How to Perform Data Transformations › Define and Send Escalation Emails › Create and Apply Data Transformations › Identify Users with Expired Role Memberships

Identify Users with Expired Role Memberships

To ensure that managers do not certify invalid role memberships, filter out users with expired role memberships based on the end date.

Follow these steps:

1. In PDI, in the Design tab, locate and expand the Flow step, select Filter rows, and drag it to the Transformation screen.
2. Right-click the Filter rows step and select Edit step.
3. In the Filter rows window, set the destinations steps as follows:
   • Send 'true' data to step: Text file output
   • Send 'false' data to step: Dummy (do nothing)
4. Create the following condition in The condition box:

   End Date < LastValidDate
   

   AND
   

   End Date IS NOT NULL
   

   This condition compares the End Date with the LastValidDate. If the End Date occurred before the LastValidDate, the link has expired.

5. Click Ok.

   You have created a filter to identify users with expired role memberships based on a defined end date.

   You have added the output steps to identify users with expired role memberships. When you run the transformation, it identifies all users with expired role memberships.