Value Mapping

[Former Member]

Hi All,

I have a requirement to enter the values in value mapping as specified below.

Source - Target

ABC - 123

DEF - 123

GHI - 456

But I am not able to enter two same values in the target, it's quite common to have more than one target values of same kind. Is there any way I can achieve this in Value mapping.

Regards,

Bharani

[Former Member · Accepted solution]

Hi,

Create a value map with one source and target.

Like ABC -123.Give the group name.

save the values.Then select the group.

It will show ur source schema and agency, target schema and agency.

Now copy the source schema and agency.It will ask allow duplicates.Choose yes.

It will allow to create a duplicate.

Regards,

Prakasu

[Former Member · Accepted solution]

As said, it asked me about the duplicates and I have said Yes, so it has created a duplicate row with same Agency and Scheme, but still when I enter the value, it says that Value already exists. I have also tried by giving different group name, and it does not work...

Regards,

Bharani

[Former Member · Accepted solution]

Hi,

In that there is no need of entering 2 values.For your case source fields is different.There is no need of entering target once again.

Just add the source agency and source schema.

The logic is,

ABCand DEF-source then target is 123.

Regards,

Prakasu