Now, suppose that we have a similar file, but this time, there is a comment related to the injury:
person_id;injury_type;injury_side;injury_date;comment812;elbow;left;2018-05-19;Season 2018813;shoulder;left;2018-05-15;playing football141;other-excused;;2018-05-26;serious injury241;other-excused;;2018-05-26;serious injury
In this case, if the injury exists in the Injuries table, we want to update the comment:
- Create a new transformation and use it to read the more_injuries_with_comments.txt file.
- From the Output folder, drag and drop an Update step. Create a hop from the Text file input step to this one.
- Double-click on the Update step. In the Connection option, select the Sports database connection.
- As the Target table, type ...