Value and UOM - Combine display or Individual display

[Former Member]

Hi All,

I have a source file which has Price value and UOM (for ex:USD),

1) how do I make this combine into one field during import;

2) if its single field in the source how do i make this separate during the import.

kindly let me know step by step solutions...

cheers

Raj

[Former Member · Accepted solution]

In addition to the above reply,

For storing Price field, you can create a field of data type "Currency".

You can specify the default currency in the MDM Console.

While importing data via the Import Manager, you dont have to worry about the currency Code field, if all the source records are for the default currency.

The default Currency code is added automatically.

[Former Member]

Alexander,

1) While in the Import Manager - go to the Partition Field/Value tab. Add the two fields you want to combine under the Source Partitions > Partition by area. Then select to Combine the two fields. You can right click on the combined fields to set the delimiter, or set this under the Configurations > Options settings.

2) While in the Import Manager - under the Source Hierarchy right click on the field you want to separate during import. From here you can set the Split Delimiter for Multiple Fields (: ; _ ... whatever you want to use). Then right click on it again and select Split into Multiple Fields. This will create new fields with the data split to map for the import

Hopefully this helps,

Tim