Import issue for value combinations

[Former Member]

Hi

I am facing an issue with the importing of unique value combinations.

I am importing region & Country into a lookup table that has a field for region & another field for country. Region key can however be duplicated across different countries.

For eg: For country Great Britain - region is GR- Grampian (code GR) & For Italy - region is Grosetto (code GR)

If i import just field by field, only one value of GR will be imported as the Region code is mapped to the remote key & remote key expects unique values. If i import by value combination, then both the country+region code will be written to the remote key.

Is there any other way i can import these values so that i just have the region code in my remote key?

Regards

Arvind

[Former Member]

Hi Arvind,

If you want that in MDM while importing source values you need to allow duplicates to be imported a sit is without letting the Duplicate values merge in the import manager stage then try this:

- In Import manager Configuration options

- Import>Merge Source records using key fields By default thsi option is ON you need to turn it off if you do not want the source records to get merged.

Merge Source RecordsUsing Key Field

Whether to collapse and merge duplicate source records for import as a single virtual source record.The Merge Source Records Option) (No/Yes).

Try this option and see if it works as you need it.

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Hey,

To populate the region table with the Unique Key combinations of Region+CountryCode ( where region code can be duplicate)...

1. If these two fields are Display Fields --> Choose Compound field method.

2. Or Use Partition method.

I am still not clear about storing region values(only) to remote key table;

thanks

Alexander

[Former Member]

Hi

The issue is not about combining them, the intention is to import those value combinations as unique values & the remote key has to identify all of them as unique values. Normally only distinct values are written to the key mapping.

Regards

Arvind