Let's look at the first exercise again, where we read a file containing surveys. On that occasion, we read all of the information in the file. Now, suppose that we are interested in just a few fields: room_id, room_type, neighborhood, overall_satisfaction, accommodates, and price. Also, we want to rename some fields, and we want them in a different order.
There is a very easy way to do this, as follows:
- Open the transformation created in the first exercise and save it under a different name. You can do so from Main Menu or Main Toolbar.
- From the Transform folder, drag and drop a Select values step. Create a link from the Text file input file step to this new step.
- Double-click on the Select values step. We will ...