Data processing information

Configure the data processing information settings.

In the DataMagic Management screen, click the Data processing to display the Data Processing Information List screen, and then click the New button to display the Data Processing Settings screen. Configure the settings as shown below and save them.

1. Enter cnv35 in the ID field.

2. Configure the settings for the input file (C:\Examples\35\input\sampleIN35.csv) and the extraction condition.

Select an input file format in the Object palette, and then drag and drop it on the input area. Double-click the icon to display the Input Settings screen.

Configure the settings as shown below.

Screen 8.318 Input Settings screen

3. Configure the settings for the output file (C:\Examples\35\output\sampleOUT35.csv).

Select an output file format in the Object palette, and then drag and drop it on the output area. Double-click the icon to display the Output Settings screen.

Configure the settings as shown below.

Screen 8.319 Output Settings screen

4. Setting virtual tables

To count the records, set the input file as a virtual table.

In the Data Processing Settings screen, double-click the Virtual table button to bring up the Virtual Table Settings screen. Specify the same Format, ID and File name as the input settings and click the Import Fields button. Then, check all the displayed field names and save the settings.

Screen 8.320 Virtual Table Settings screen

5. Setting extraction conditions

Prepare conditions that perform the following processing:

Pre-processing: Outputs "Prefecture", "Region" and "Number of records" as the header record.
Extraction condition: Outputs the data record.

The following are the settings necessary to prepare those extraction conditions.

1) Creating a pre-processing

Drag and drop the pre-processing icon of the object palette onto the condition area. The pre-processing does not require any settings.

2) Creating the extraction conditions

Create the extraction condition. In the Extraction Condition Settings screen, set as indicated below.

Table 8.21 Settings in the Extraction Condition Settings screen
Extraction condition name	Comparison source			Comparison target		Operator	Extraction condition
Extraction condition 1	Record	Input record numbers		Fixed value (numeric value)	1	>=	1

6. Setting mapping information

In the Data Processing Settings screen, use drag-and-drop operation to set mappings as in the following figure.

Screen 8.321 Setting mappings

1) Relation line from the pre-processing

Outputs the header record before the conversion processing.

Screen 8.322 Mapping information (pre-processing)

Table 8.22 Settings in the Set Mapping Information screen (pre-processing)
Field on the output side	Output information tab
Field on the output side	Field type	Value
Prefecture	Fixed value (fixed character string)	Prefecture
Region	Fixed value (fixed character string)	Region
Number of records	Query value	select count(*) from VT_TABLE1

2) Relation lines from the extraction condition to the output file

Outputs the respective fields of the input record.

Screen 8.323 Mapping information (extraction condition)