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
transformations
folder with the nametop_scores_flow_preparing.ktr
.Go back to the original transformation and select the rest of the steps, that is, the Mapping and the Text file output steps.
Copy the steps and paste them in a new transformation.
From the Job category of steps select a Get rows from result step, drag it to the canvas, and create...