Time for action – inserting new products or updating existing ones

So far, you created the jigsaw puzzles database and loaded a list of the puzzles' manufacturers. It's time to begin loading information about the products you will sell, that is, the puzzles.

Suppose that in order to show you what they are selling, the suppliers provide you with 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. Find the productlist_LUX_200908.txt file from the downloaded code bundle and save it in the folder pointed to by your ${LABSINPUT} variable.

2. Open Spoon and create a new transformation.

3. Add a Text file input step and configure it to read the file productlist_LUX_200908.txt. As Separator, type |. In order to fill in the fields grid, use the Get Fields...