Importing Member Mappings

You can import member mappings from a selected CSV and TXT, and you can create mappings. Import member mappings support merge or replace modes, along with validate or no validate options for target members.

To import member mappings:

On the Workflow tab, under Data Load, select Data Load Mapping.
From the Import drop-down, select Current Dimension or All Dimensions.
The Select file to import screen is displayed.
Navigate to the file to import and click OK.
Optional: If necessary, click Upload to navigate to the file to import, and then click OK.

In the member mapping import files, FDMEE supports one of the following characters as column separators:

,
|
;

The order of the columns:

source value
target value
rule name
rule description

Note:

If you add a minus sign in front of a target account value, then it is imported with the “Change Sign” selected.

The mapping details are as follows:

Table 24. Supported Column Separators

Column	Mapping
100, Cash, R1, Explicit Mapping	Explicit Mapping
100>199, Cash, R2, Between Mapping '	“>” indicates its BETWEEN mapping.
1*, Cash, R3, Like Mapping	“*” indicates its LIKE mapping.
#MULTIDIM ACCOUNT=[4*] AND UD3=[000],Cash,R4,Multi Dimension Mapping	“#MULTIDIM” indicates a multiple dimension mapping. The actual column name used for the mapping is the Data Table Column Name. The easiest way to create a multiple dimension mapping is to create a mapping through the user interface and export it to the file. You can then modify the file by additional mapping.
10, 20, In Mapping	Source values are enclosed with “” and separated by a comma (,) for the In mapping. For example IN 10, 20 is defined as “10,20” in the source column of the import file.