In this recipe, you will learn the use of the Text file input step. In the example, you have to read a simple file with a list of authors' information like the following:
"lastname","firstname","country","birthyear" "Larsson","Stieg","Swedish",1954 "King","Stephen","American",1947 "Hiaasen","Carl ","American",1953 "Handler","Chelsea ","American",1975 "Ingraham","Laura ","American",1964
In order to continue with the exercise, you must have a file named authors.txt
similar to the one shown in the introduction section of this recipe.
Carry out the following steps:
Create a new transformation.
Drop a Text file input step to the canvas.
Now, you have to type the name of the file (
authors.txt
) with its complete path. You do it in the File or directory textbox.Click on the Add button. The...