Time for action—calculating the top scores with a subtransformation
Let's modify the transformation that calculates the top scores to avoid unnecessary duplication of steps:
- Under the
transformation folder, create a new folder named
- Create a new transformation and save it in that new folder with the name
- Expand the Mapping category of steps. Select a Mapping input specification step and drag it to the work area.
- Double-click the step and fill it like this:
- Add a Sort rows step and use it to sort the
score field in descending order.