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 cnv11 in the ID field.
2. Configure the settings for the input data (ID=INDB11) 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.106 Input Settings screen
3. Configure the settings for the output file (C:\Examples\11\output\sampleOUT11.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.107 Output Settings screen
4. Link the extraction condition and output file.
Choose the Extraction Condition icon and drag and drop it onto the Output file icon on the right to draw a relation line.
Screen 8.108 Mapping of extraction conditions and output file
5. Specify the output format.
1) Display the Set Mapping Information screen.
Double-click the relation line between extraction condition 1 and the output file. This displays the Set Mapping Information screen.
2) Check the input-side tree view.
The input-side (left) tree is displayed as follows.
If the actual display varies from the following, check the ID settings and input file settings.
Screen 8.109 Input side tree
3) Create fields in the output-side tree.
Click the Add multiple button at the top of the output-side tree (right) to display the Additional Field Settings dialog box. Enter 5 for the number of additional fields in the dialog box and click the OK button. Five new fields are added to the tree.
Screen 8.110 Additional Field Settings screen
4) 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.
The output format of the fifth output item is set with numeric character string.
Screen 8.111 Input-Output relation lines
5) Register the mapping information.
Click the OK button to register the mapping information.
6. Click the Apply button to save the data processing information.