Using PowerExchange to Validate and Extract Data in Flat Files

Back Next

Define Data in Multiple Flat Files at a Time

You can create a data map for multiple flat files at a time if all the flat files in the group have the same data format.

List the file path and file names of the flat files in a text file.

The following image shows an example text file with a list of flat files:

Open PowerExchange Navigator.

On the

Resource Explorer

pane, right-click the Data Map folder and select

Add Data Map

The

Name

dialog box appears.

Complete the following information in the

Name

dialog box:

Enter a

Schema Name

Select

SEQ

from the

Access Method

list.

Enter

Data Map Name

Disable

Import Record Definitions

Click

The

SEQ Access Method

dialog box appears.

Complete the following information in the

SEQ Access Method

dialog box:

Use the browse button in

File Name

to select the text file that contains the list of flat files.

Optionally, select the

Field Separator

check box.

Enable

File List Processing

Click View File
to open the text file that contains the list of flat files

The Data File Remote Node
dialog box appears.

Complete the following information in the

Data File Remote Node

dialog box:

Enter the

User ID

Optionally, enter the

Password

Enter

local

as the location if you have the flat file saved locally on your computer.

Click

The text file with the list of flat files appears.

Review and close the file.

Click

Finish

on the

SEQ Access Method

dialog box.

Map column datatypes. For more information, see Step 2. Assign Datatypes.

Add a table and validate data. For more information, see Step 3. Add Table and Validate Data.

Correct and extract data. For more information, see Step 4. Correct and Extract Data.

The

Database Row Test Output

window displays the records from the flat files in the group.

Rename Saved Search

Table of Contents

Using PowerExchange to Validate and Extract Data in Flat Files

Using PowerExchange to Validate and Extract Data in Flat Files

Define Data in Multiple Flat Files at a Time

Define Data in Multiple Flat Files at a Time