Time for action—splitting the generation of top scores by copying and getting rows
Now you will split your transformation into two smaller transformation so that each meets a specific task. Here are the instructions.
- Open the transformation in the previous tutorial. Select all steps related to the preparation of data, that is, all steps from the Text file input step upto the Formula step.
- Copy the steps and paste them in a new transformation.
- Expand the Job category of steps.
- Select a Copy rows to result step, drag it to the canvas, and create a hop from the last step to this new one. Your transformation looks like this:
- Save the transformation in the ...