When you send data to a file, you have to provide not only the name and location but also information about the format you want for the file. This includes the delimiter character, type of encoding, and whether to use a header, among other settings.
Regarding the fields, just like in the Input steps, you may use the Get Fields button to fill the grid. In this case, the grid is filled based on the data that arrives from the previous step. You are not forced to send every piece of data coming to the Output step, nor to send the fields in the same order, as you can figure out from the examples.
If you leave the Fields tab empty, PDI will send all the fields coming from the previous step to the file. ...
