Edit and save the transformation

Try Pentaho Data Integration and Analytics
Version
10.1.x
Audience
anonymous
Part Number
MK-95PDIA000-15
Follow these steps to edit and save your transformation.
  1. In the Content tab, change the Separator character to a comma (,) and confirm that the Enclosure setting is a quotation mark ("). Verify that the Header option is selected.
  2. Under the Fields tab, click Get Fields to retrieve the data from your CSV file.
  3. The Number of lines to sample window appears. Enter 0 in the field, then click OK.

    Results from Get Fields in the Fields tab
  4. If the Scan Result window displays, click Close to close it.
  5. Click Preview rows to verify that your entries are correct.
    1. When prompted to enter the preview size, click OK.
    2. Review the information in the window, then click Close.
  6. Click OK to exit the Text File input window.
  7. Save the transformation.