In Write to Spreadsheet, the Fields tab defines the names, position, and data types of the fields in the file. After you define an output file on the File Properties tab you can define the fields. If the option Nullable is checked and the Name field contains a null value, then the dataflow will write the null value in the spreadsheet.
If the output file contains a header record, you can quickly define the fields by clicking Regenerate.
To define fields with default values for position, length, and data type, click Quick Add and select the fields to add.
If the input file does not contain a header record, or if you want to manually define the fields, follow these steps:
After defining the fields in your output file, you can edit its contents and layout.
Option Name |
Description |
---|---|
Add | Adds a field to the output. You can append a field to the end of the existing layout, or you can insert a field into an existing position and Write to Spreadsheet will adjust the remaining fields accordingly. |
Modify |
Modifies the field's name and type. |
Remove |
Removes the selected field from the output. |
Move Up/Move Down |
Reorders the selected field. |