Programming Guide › Transforming Data › Create and Apply Data Transformations › Add the Output Steps to Delete Users with Expired Role Memberships

Add the Output Steps to Delete Users with Expired Role Memberships

To delete users with expired role memberships before certification, add the output steps to the transformation.

Follow these steps:

1. In PDI, in the Design tab, locate and expand the Flow step, select the Dummy (do nothing) step, and drag it to the Transformation screen.
2. Create a hop between the Filter Rows step and the Dummy (do nothing) step.

   All valid links are sent to the Dummy (do nothing) step.

3. On the Design tab, locate and expand the Output step, select the Text file output step, and drag it to the Transformation screen.
4. Right-click the Text file output step and select Edit step.

   The Text file output window opens.

5. Under the File tab, provide a filename for the text output file.
6. Under the Fields tab, click Get Fields.
7. Delete all fields except for the following and click Ok:
   • 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. On the Design tab, locate and expand the RCM Output step, select the Delete User-Resource Links step, and drag it to the Transformation screen.
10. Right-click the Delete User-Resource Links step and select Edit step.

    The !Delete User-Resource Links! window opens.

11. In the General tab, in the RCM Configuration section, map the following fields, and click Ok:
    • Person ID Field=PersonID
    • Res Name 1 Field=ResName1
    • Res Name 2 Field=ResName2
    • Res Name 3 Field=ResName3

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