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 cnv16 in the ID field.
2. Configure the settings for the input file (C:\Examples\16\input\sampleIN16.dat) 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.143 Input Settings screen
3. Configure the settings for the output file (C:\Examples\16\output\sampleOUT16.dat).
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.144 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.145 Mapping of extraction conditions and output file
5. Specify the output format.
1) Display the Set Mapping Information screen.
Double-click the Mapping icon created on the connection line between the Extraction Condition icon and Output icon. This displays the Set Mapping Information screen.
2) Check the tree view.
The tree view of the input (left) should show the format information (ID=INFMT16) fields.
The tree view of the output (right) should show the format information (ID=OUTFMT16) 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.146 Input-Output relation lines
4) Register a fixed character string to the output field KEY.
Select the field KEY in the output-side tree and click the Add row button in the Output information area. This displays the Output Information Settings screen. Select Fixed, set the Category to Fixed character string, and enter KEY1 in the Value field. When you finish, click the OK button.
Screen 8.147 Output Information Settings screen (Fixed value)
By selecting the field KEY in the output-side tree on the Set Mapping Information screen, you can see that KEY1 is set as the fixed character string as shown in the screen below.
Screen 8.148 Mapping output information
5) Register a numerical formula to the output field newdata.
Select the field newdata in the output-side tree and click the Add row button in the Output information area. This displays the Output Information Settings screen. Select Numeric operations and enter 123 in Formula. When you finish, click the OK button.
Screen 8.149 Output Information Settings screen (Numeric operations)
By selecting the field newdata in the output-side tree on the Set Mapping Information screen, you can see that 123 is set as the numerical formula as shown in the screen below.
Screen 8.150 Mapping output information
6) Register the mapping information.
Click the OK button to register the mapping information.
6. Click the Apply button to save the data processing information.