Analyst Tool Guide

Back Next

Adding a Fixed-width Flat File

When you import a fixed-width flat file to a project or folder, you can set column breaks to format the data.

On the

New

header, click

Flat File Data Object

The

Add Flat File wizard

appears.

Choose to browse for a location or enter a network path to import the flat file.

To browse for a location, select

Browse and Upload

and click Choose File
to select the flat file from a directory that your machine can access.

To enter a network path, select

Enter a Network Path

and configure the path and file name of the file.

Click

Select

Fixed-width

Click

Configure the flat file options, and preview the flat file data.

Select a code page that matches the code page of the data in the file.

Optionally, click the

Refresh

icon in the

Preview

panel to update preview changes to the flat file data.

Choose to set, remove, move, or edit column breaks.

To set a column break, click within the

Preview

panel.

To remove a column break, double-click the column break.

To move column breaks, drag them.

To edit column breaks, click the

Edit Breaks

icon and use the

Edit Breaks

dialog box to modify column breaks.

Click

Optionally, change the

Column Attribute

Click

Configure the name, optional description, and the location in the

Folders

panel where you want to add the flat file.

The

Flat Files

panel displays the flat files that exist in a project or folder.

Click

Finish

The Analyst tool displays the properties for the flat file on the

Properties

tab. View the data preview for the flat file on the

Data Preview

tab.

Flat File Data Objects

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Analyst Tool Guide

Analyst Tool Guide

Adding a Fixed-width Flat File

Adding a Fixed-width Flat File