Do you remember the section named Time for action – Avoiding errors while converting the estimated time from string to integer from Chapter 2, Getting Started with Transformations. In that exercise, you detected the rows with an invalid estimated time, reported the error, and discarded the rows. In this section, you will fix the errors and keep all rows.
Open the transformation you created in that section and save it with a different name.
After the Write to log step, remove the fields
estimated
anderror_desc
. Use a Select values step for that purpose.After that, add an Add constants step. You will find it under the Transform category.
Double-click on the step and add a new field. Under Name type
estimated
, under Type select Integer, and as Value type180
.Click on OK.
Finally, create a hop from this step towards the calculator. You will have the following:
Select the calculator and do a preview. You will see this...