Programming Guide › Transforming Data › Create a Transformation › Add the Output Steps to Delete Users with Expired Role Memberships

Add the Output Steps to Delete Users with Expired Role Memberships

Add the output steps to the transformation to delete users with expired role memberships before certification.

Follow these steps:

1. Under Flow, select the Dummy step and drag it to the Transformation screen.
2. Create a hop between the Filter Rows step and the Dummy step.

   All valid links are sent to the Dummy step.

3. Under Output, select the Text file output step and drag it to the Transformation screen.
4. Right click on the step and select Edit step.
5. Under the File tab, provide a filename for the text output file.
6. Under the Fields tab, click Get fields.
7. Keep the following fields:
   • PersonID
   • ResName1
   • ResName2
   • ResName3
   • Start Date
   • End Date
8. Create a hop between the Filter Rows step and the Text file output step.

   All users with expired links are captured and sent to the Text file output.

9. Under CA GovernanceMinder Output, select the Delete User-Resource Links step and drag it to the Transformation screen.
10. Right click on the step and select Edit step.
11. Map the following fields:
    • Person ID Field=PersonID
    • Res Name 1 Field=ResName1
    • Res Name 2 Field=ResName2
    • Res Name 3 Field=ResName3
12. Click Ok.

    When you run this transformation, it deletes all users with expired role memberships.