How to design conversion processing that uses variables

(1) Check the content of the processing

Check the conversion processing you want to perform using DataMagic.

(2) Consider using variables

First of all, make sure that the desired processing can be performed by using the condition settings, numeric operations and functions of DataMagic. If you want to retain the value of an input field and perform processing that spans different records, consider using variables. In the course of such consideration, see Field types that can be used for a variable and Mapping variables to understand the rules for using variables.

(3) Design the processing flow

Examine the entire processing flow from the load of the input record to output of the file, and list the variables used in the processing. In addition, check the numeric operations and functions that can be used in DataMagic and consider how the processing can be made possible by combining variables with those operations and functions.

(4) Design the variables and conditions

Based on the processing flow design, design the variables and conditions that are set for the mapping in DataMagic. Note the following points regarding the respective design tasks.

Design the variables to use

For each of the variables, determine the variable name, variable type (character or numeric value), initial value and the type and range of the value stored in the variable.

Note that a variable name cannot be used more than once in a single mapping setting. Be sure to provide a unique variable name. If a variable is to be used in numeric or date operations, the variable name must not contain either of the two halfwidth parentheses "(" or ")".

Design the conditions to use

Determine the type of the conditions. Then, for each condition, determine the content of the condition and processing. In addition, decide on the numeric operations and computational functions to use.