Create a self-join
- Select the table in the Source Tables pane and the Target Tables pane and click the Map icon.
- Enter an alias for each occurrence and save.
- Select a transformation type of Join for the target table.
- Click the Join icon and define the join. See Join.
- Click the Map Column icon for the target table. See Map at the column level.
Parent topic: Map at the table level