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 cnv28 in the ID field.

2. Configure the settings for the input file (C:\Examples\28\input\sampleIN28.csv).

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.253 Input Settings screen

3. Configure the settings for the output file (C:\Examples\28\output\sampleOUT28.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.254 Output Settings screen

4. Link the extraction condition and output file.

Choose the Extraction Condition icon and drag and drop it onto the File icon on the right to draw a relation line.

Screen 8.255 Mapping of extraction conditions and output file

5. Set the extraction condition.

1) Display the Extraction Condition screen.

Double-click the extraction condition. The Extraction Condition screen is displayed.

2) Display the Condition Setting Details screen.

In the condition list, click the Add button. This displays the Condition Setting Details screen.

3) Set the comparison source, operator, and comparison target.

Specify to Comparison source as below.

Comparison source type: : Input field
Field No.: : 1
Option button: : Select "Common components"
ID: : SAISON_TOUPPER

Specify to Operator as below.

Operator: : ==

Specify to Comparison target as below.

Comparison target type: : Fixed value
Type: : Character string
Value: : AAAA

Screen 8.256 Condition Setting Details screen

4) Close the Condition Setting Details screen.

6. Specify the output format.

1) Display the Set Mapping Information screen.

Double-click the Mapping icon created on the relation line between the Extraction Condition icon and Output icon. This displays the Set Mapping Information screen.

2) Check the tree view.

Check the tree view of the input (left) should show the fields.

Check the tree view of the output (right) should show the fields.

3) Draw relation lines.

You can draw a relation line by dragging and dropping the field node in the left tree to the field node in the right tree. Draw relation lines as shown in the screen below.

Screen 8.257 Input and output connections

4) Register the mapping information.

Click the OK button to register the mapping information.

7. Click the Apply button to save the data processing information.