Can I match and merge data stored in lookup table?

[Former Member]

Hi all,

I loaded company information into MDM, which includes company's name and address. because one company may have more than one location I created a lookup table for address. when I check the address table I found there are some data very similar, e.g. "3303 Harbor Blvd Ste B7" and "3303 Harbor Blvd Suite B-7".

How can I merge these data stored in lookup table?

thanks a lot!

[former_member205403 · Accepted solution]

Hi Bin,

Yes u can match and merge data stored in the look up table.Steps for performing this are as follows:

<b>1--></b>Switch to match mode.

<b>2--></b>Select the destination lookup table .It will not appear in the dropdown list,you have to select it from<b> View -->Select Table --> More -->Destination table Name</b>.

<b>3--></b>Now define Transformation ,Rules and Strategies as required by you and perform the match and merge.

Hope this will help you.Please remark if helpful.

Thanks,

<b>Shiv Prashant Dixit</b>

[Former Member · Accepted solution]

Hi Shiv,

that's really a timly response! It works, thanks very much!

PS: MDM development team should take the improvement of user interface seriously, right?

best wishes

Bin