In order to insert new data into a table in a relational database, PDI has a couple of steps, the Table output step being the simplest option. In this case, we will read a file with information about new injuries and insert it into the injuries_phases table by using this step. The file is available with the bundle material for this chapter, and it looks as follows:
person_id;injury_type;injury_side;injury_date812;elbow;left;2018-05-19813;shoulder;left;2018-05-15119;calf;both;2018-05-20370;wrist;;2018-05-08241;other-excused;;2018-05-26790;shoulder;;2018-06-30941;knee;right;2018-07-01151;knee;right;2018-07-11
The instructions for inserting the file are as follows:
- Create a transformation, and use a Text file input step to read ...