Programming Guide › Transforming Data › Create a Transformation › Add the Filter Step to Identify Expired Role Memberships

Add the Filter Step to Identify 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. Under Flow, select the Filter Rows step and drag it to the Transformation screen.
2. Right click on the step and select Edit step.
3. 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 identifies if the End Date is before the LastValidDate, meaning that the link has expired.

5. Click Ok.