Create a self-join

  1. Select the table in the Source Tables pane and the Target Tables pane and click the Icon shows 2 data sheets with a 2-way arrow.Map icon.
  2. Enter an alias for each occurrence and save.
  3. Select a transformation type of Join for the target table.
  4. Click the Join icon and define the join. See Join.
  5. Click the Icon shows 2 data sheets with a 2-way arrow.Map Column icon for the target table. See Map at the column level.