DataFlux Data Management Studio 2.6: User Guide
You can add a Text File Output node to a data job to create a plain-text file with the results of your data job whenever rows of data are received. The node is closed as soon as there are no more rows. This procedure makes the files available to other nodes on the same page. Once you have added the node, you can double-click it to open its properties dialog. For an example of how this node can be used, see Converting and Extracting a Document.
The properties dialog includes the following elements:
Name - Specifies a name for the node.
Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the node.
Output Table - Enables you to enter the path and name of your output file. You can also click Browse to navigate to the output file location.
Text Qualifier - Specifies what character, if any, should be inserted at the beginning and end of each field value. The two available qualifiers are the single quotation (') and double quotation (") marks.
Encoding - Displays a drop-down list of encoding options.
Field Delimiter - Specifies the type of field separator to use for the resulting text file.
Include Header Row - When selected, creates a row of field names at the top of your text file to identify each output field.
End of Line - Indicates the type of action that occurs at the end of the line. Select one of the following options:
CR - (Carriage Return) Adds a carriage return at the end of the line.
LF - (Line Feed) Adds a line feed to separate lines. This option is designed mostly for UNIX, which expects only a line feed to move to the next line.
CR+LF - (Carriage Return/Line Feed) Adds a line feed along with a carriage return to move to the next line. This option is designed mostly for DOS, which expects a carriage return and a line feed to move to the next line.
NEL - (New Line)Adds a new line. This option is designed mostly for IBM systems.
Display file after job runs - When selected, opens the completed text file in your default text editor.
The Output fields section of the dialog includes the following elements:
Available - Displays the fields that you can make available for the next step in your data job. Items displayed in this list are dependent on your data sources and any preceding steps in your data job.
Selected - Displays the fields that will be made available to the next node in your data job.
Export - Enables the import functionality available in the External Data Provider step. You can store the file format of a data source in a .dfl file to be used later to restore the same file format. The .dfl file has the same structure and type as the .dfl file that is provided when you export file layouts with fixed width text file and delimited text file data inputs. The .dfl file can restore the file format in the EDP step as easily as importing the file itself.
You can access the following advanced properties by right-clicking the Text File node:
|
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfU_PFOutput_TextFile.html |