Data processing information
Specify settings for data processing information.
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. Specify settings as shown below, and then save the settings.
1. For ID, enter cnv13.
2. Set the input file (C:\Examples\13\input\sampleIN13.xlsx) 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.
Specify the following settings.
Screen 8.121 Input Settings screen
3. Specify settings for the output file (C:\Examples\13\output\sampleOUT13.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.
Specify the following settings.
Screen 8.122 Output Settings screen
4. Link the extraction condition and output file.
Choose the Extraction Condition icon, and then drag and drop it onto the file icon on the right to connect the two icons.
Screen 8.123 Mapping between the extraction condition and the output file
5. Specify settings for the output format.
1) Display the Set Mapping Information screen.
Double-click the mapping icon on the relation line between the Extraction Condition icon and the output icon. The Set Mapping Information screen is displayed.
2) Check the input tree.
Make sure that an Excel information field (ID=INEXCEL13) is displayed at the top of the input tree on the left.
3) Create a field in the output tree.
Click the Add multiple button near the top of the output tree on the right. The Additional Field Settings dialog box is displayed. In No. of additional fields, enter 3, and then click the OK button. Three fields are added to the tree.
Screen 8.124 Additional Field Settings dialog box
4) Add relation lines.
To add a relation line, drag one field node from the left tree and drop it onto another field node on the right tree. Add relation lines as shown below.
Screen 8.125 Input/Output relation lines
5) Register mapping information.
Click the OK button to register mapping information.
6. Click the Apply button to save the data processing information.