Importing Key Combinations of a Lookup table.

[former_member611093]

Hi, I have created a lookup table which is equivalent to a check table in R3. For example table named, SPT (Special Procurement Type), Which has a key combination (Composite Keys) in R3 itself and the keys are Plant + Procurement Type and so in MDM Look table both keys are defined as display fields. The problem comes in automating the import. In IM source, both key fields are separate fields, I tried combining the field using Partion, but Automap is not working and so the import automation process. Any thoughts/advices on tackling this issue is appreciated.

Thanks

Job.

[Former Member]

Hi Job,

IF u combine the fields in partition and then if try to do value mapping automatically,then it is not possible .There u have to map manualy .Automap in value mapping can be done only when values are not combination but single.

Like

Source----

---

Destination

abc----

---

<null>

def----

---

abc

xyz----

---

def

-

---

xyz

But if it is like:

Source----

---

Destination

abc,12----

---

<null>

def,23 -

---

abc,12

-

---

def,23

in above case it is a combination so not possible.

I hope u im able to make u understand.

If this has helped u then do Reward points.

Regards,

Neethu Joy

Edited by: Neethu joy on Dec 31, 2007 3:17 PM

Edited by: Neethu joy on Dec 31, 2007 3:19 PM

Edited by: Neethu joy on Dec 31, 2007 3:24 PM

[Former Member]

Hi Job,

Just trying to understand, if the composite keys are two separate fields in your lookup table , why are you combining them into a single.

You neway have defined them as a display fields , you can even go and make them as a unique fields just to ensure that the combination will not repeat.

Let me know in case of any clarification.

Thanks & Regards,

Amol.

[former_member611093]

Hi Amol,

Thanks for the reply. I understand what you are saying. I think your solution is good when I import (Sync) the Look up table itself. But my scenario is that I am importing the main table, trying to map the lookup field (in main table), that referencing the lookup table that has key combinations.

My source

-

---

Material #

Plant

Proc Type

field4

field5

My Destination (Main table fields)

-

---

Material #

SPT (Lookup field - Referencing Lookup table SPTs)

field3

field5

Lookup Table SPTs

-

---

Plant - Display Field

Proc Type - Display field

Description

Hope I explained it correctly this time :).

Thanks again for your time.

Job.

[Former Member]

Hi Job,

Yep got the problem now .

I guess you are facing this problem during Value Automap.

So check for delimiter while you are trying to combine these fields. You can change this delimiter from Import Manager's "Configuration -> Options".

Regards,

Amol.