Import Rule Set
- Julia Ratniece
The Import Rule Set tab is used to convert source data into AARO data if data needs to be converted (for example, source data has values not defined in AARO).
A rule consists of the following fields:
Column | Description |
|---|---|
Row number | A sequence number automatically generated per row. It is possible to change the sequence number for the rule manually. |
Multiplier | Multiplier applied to the LOC or TransAmount value before import is performed. Can be positive or negative. The default value is '1'. |
File Column 1 | First dimension name from the source file to be converted (e.g. Business Area, Account, etc), value is selected from a drop-down list. This field is mandatory. |
File Value 1 | First dimension value from the source file to be converted (e.g. HEMMA, 2440, etc) for the dimension from the File Column 1 field. Wildcards can be used for this field. This field is mandatory. |
File Column 2 | Second dimension name from the source file to be converted, if required, value is selected from a drop-down list. This field is optional. |
File Value 2 | Second dimension value from the source file to be converted. Wildcards can be used for this field. This field is optional. |
AARO Dimension | AARO dimension name, parameters defined in the File Column fields will be converted to. This field is optional. |
AARO Value | AARO dimension value, parameter values defined in the File Value fields will be converted to. This field is optional. |
It is possible to use "wildcards" in rules. The wildcard character '*' can be used in various ways, such as:
*ABC – any values ending with the characters ABC;
ABC* - any values starting with the characters ABC;
*ABC* - any values containing the characters ABC.
* - no value (the blank value) or any value.
In the example below, the rule will convert rows in the file specification containing account starting with '24', (e.g.'2440' and '2464') to the entries with the account='2440' with LOC multiplied by '-1'.
Import rule set example
It is possible to define a range by entering '..' in the Value field. For example, '2440..2464' would define all numbers in the range between '2440' and '2464'.
It is possible to use regular expressions in rules.
In the sample below, rows in the file specification containing accounts in the range '1910' - '1990' will be multiplied by '-1', and rows containing companies with name length = 7 characters will be converted to the entries with the 'ATHENS' company.
Each conversion rule is applied to the whole imported file in the order of the rules sequence numbers (row numbers).
The steps in which rules are processed are:
Rules are executed row by row in the import rule set according to row numbers.
The imported file is checked for a parameter/value in the record specified File Column1/File Value1 in the import rule set and, if specified, in combination with the File Column2/File Value2. If found, the parameter/value from the file is replaced with AARO Dimension/AARO Value from the rule.
It is possible to copy rules to Excel by selecting rules in an Import Rule Set, pressing [Ctrl]+[C], then selecting a cell in an Excel sheet and pressing [Ctrl]+[V].
Add import rule
To add an import rule row:
In the Import Rule Set tab, right-click a header, select the Insert row below option.
Adding an import rule rowThe new import rule row is added.
The new import rule rowAdd rule details, as described in the section above.
Remove import rule
To remove an import rule row, right-click an import rule row and select the Remove row option.
The import rule row will be removed.