In this example, we will just be
defining the columns though.
1. Under the Data Explorer tab, right-click on Data Sets and select
New Data Set.
2. Enter the following information:
Data Set Name: dsetFlatFilePayments
Data Source: dsFlatFilePayments
Data Set Type: Flat File Data Set
Click Next.
3. As the Flat File Data Source defined a directory where the data files are
located, we need to select the appropriate text file from the Select file
drop-down list. Choose the paymentInfo.csv file created during the Data
Source exercise.
4. There should be four columns labeled COLUMN_1, COLUMN_2,
COLUMN_3, and COLUMN_4 respectively. If we had chosen the option to
have a header row during the Data Source creation, these columns would
be named whatever the values were in the first line of the text file. For each
column, click on it, and then click on the right-pointing arrow button .
Chapter 5
[ 87 ]
5. Each of the columns should be in the grid. You can change the values of each
of the columns, such as original name, name to be used in the Data Set, and
the data type. Enter the following information for each of the columns:
COLUMN_1: Name = firstName Type = String
COLUMN_2: Name = lastName Type = String
COLUMN_3: Name = paymentDate Type = Date
COLUMN_4: Name = paymentAmount Type = Double
6. Click Finish.
Pages:
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102