DataFlux Data Management Studio 2.6: User Guide
You can add a Text File Input node to a data job. Then, you can perform the following tasks:
You should examine the structure and content of the text file in a text editor. Be sure to note features such as whether the first line contains headings, whether the file contains text qualifiers, and what delimiters are used.
Use the data that you gathered when you reviewed the text file to configure its parameters in the Text File Input Properties dialog. For example, the following display shows the parameter configuration for a text file that does not use a text qualifier and specifies comma as the delimiter.
You can generate a listing of the fields in the text file by clicking Suggest. The sample text file listed the field names in the first line, so click First row contains field names and Guess field types and lengths from file content. The following fields are displayed in the Fields section.
You can make any needed changes to the field names, field types, and field lengths in the text file directly in the Fields section of the dialog. Then, you can click OK to save the properties for the file.
You can easily preview the text file input that you added to the data job. Right-click the Text File Input node and click Preview in the pop-up menu. A preview is provided in the Details pane, as shown in the following display.
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfU_T_InputTextFiles.html |