Time for action – avoiding errors while converting the estimated time from string to integer
In this section, you will create a variation of the first transformation in this chapter. In this case, you will allow invalid data as source, but will take care of it:
- Create a transformation.
- Add a Data Grid step and fill in the Meta tab just like you did in the first section: add a string named
project_nameand two dates with the format yyyy-MM-dd, named start_date and end_date. Also add a fourth field of type
- Now also fill in the Data tab with the same values you had in that first section. For the
estimatedfield, type the following values:
You can avoid typing all of this in again! Instead of adding ...