Time for action – inserting new products or updating existent ones

So far, you created the Jigsaw Puzzles database and loaded a list of puzzles manufacturers. It's time to start loading information about the products you will sell— puzzles.

Suppose, in order to show you what they are selling, the suppliers provide you with the lists of products made by the manufacturers themselves. Fortunately, they don't give you the lists in the form of papers, but they give you either plain files or spreadsheets. In this tutorial, you will take the list of products offered by the manufacturer Classic DeLuxe and load it into the puzzles table.

1. From the Packt website, download the sample lists of products.

2. Open Spoon and create a new transformation.

3. Add a Text file input step and configure it to read the productlist_LUX_200908.txt file.

   Pay attention to the each field. It's the price of the product and must be configured as a Number with format $0.00.

4. Preview the file. You should see the following:

   

5. In the Selected...