The dataset that you create in PDI can be inserted into tables, or can be used to update existing data. In this section, you will learn how to perform these two kinds of operation. For the tutorials, we will use the Sports database that we used in the previous chapters.
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_date 812;elbow;left;2018-05-19 813;shoulder;left;2018-05-15 119;calf;both;2018-05-20 370;wrist;;2018-05-08 241;other-excused;;2018-05-26 790;shoulder;;2018-06-30 941;knee;right;2018-07-01 151;knee;right;2018-07-11
The instructions for inserting the file are as follows...