Insert / Update DB
Last updated
Last updated
Steel Wheels needs to update its Employee records as folks join and get promoted.
In this guided Lab, you will:
Insert / Update the Employees Table.
1188,Firrelli,Julianne,x2174,jfirrelli@classicmodelcars.com,2,1143,Sales Manager 1619,King,Tom,x6324,tking@classicmodelcars.com,6,1088,Sales Rep 1810,Lundberg,Anna,x910,alundberg@classicmodelcars.com,2,1143,Sales Rep 1811,Schulz,Chris,x951,cschulz@classicmodelcars.com,2,1143,Sales Rep
In Spoon, click File > New > Transformation.
Any one of these actions opens a new Transformation tab for you to begin designing your transformation.
By clicking New, then Transformation
By using the CTRL-N hot key
Drag the Text File Input step onto the canvas.
Open the Text File properties dialog box.
Ensure the following details are configured, as outlined below:
Click on the ‘Content’ tab and configure the following properties:
Click on ‘Get Fields’ button.
Click on the ‘Fields’ tab and notice the following properties:
Close the step.