Assigning GUID to duplicates

[Former Member]

I know this question has been asked a couple of times on forums but still looking for potential solution:

If I have a set of matched records and instead of merging I need to add a GUID to these matrched records how can I achieve this within MDM. I understand this is achievable via Java API but am looking for an approach within MDM Data Manager/Workflows etc to solve the same.

Any inputs would be appreciated.

[Former Member · Accepted solution]

You can add a new field to the repository to represent the global ID, and give it the number you would like. When you merge the records, set the new field to be the global ID for both records.

[Former Member · Accepted solution]

Harrison I am not merging the records - if the idea was to merge the internal remote keys woudl have done the job. Say to have 100 possible matches to 1 record in MDM.

After 100 matched records have been found by Matching process (manual or workflows) assign probably a GUID to these 101 records.

[Former Member · Accepted solution]

Why don't you just create an assignment that assigns the global ID, select all 100 records and then run the assignment on them?

[Former Member · Accepted solution]

Am sorry...

Do you mean to remember the 100 records in DM and then choose among 100000 records and then run assignment? Am not getting your idea...

If we are matching 1 vs all... we will get the match result in Match tab below - the moment we switch to Record mode the match set will disappear and only the 1 record will remain in the view...

[Former Member · Accepted solution]

Ooooh, I see your problem. Well, save the matching result as a mask, and then go execute the assignment on the records in that mask.

[Former Member · Accepted solution]

Harrison..

how do you save a match result as a Mask in DM?

[Former Member · Accepted solution]

1. First, create a mask in the masks table.

2. Switch to matching view

3. Select some records and run a "selected vs. selected" matching strategy

4. The results will show up in the Records pane, sort by score.

5. Select the records, right-click, and add to your mask.

[Former Member · Accepted solution]

Hi,

As you said, you dont want to merge records but instead you want to assign them same GUID.

May be this is some bit labourious job but your requirement can be achieved.

Procedure: Create a new field Say GUID in Main table. Create an assignment say Assign GUID with Table Field Property = GUID

In assignment Expression write anything Say your GUID number 1234

Create two workflow: say 1. workflow name = Select Duplicates

Start->Match(give strategy here)-->Stop

When you trigger this workflow Match user on the basis of strategy run Matching Duplicates have Green color which you can see in matching mode, here instead merge you can select all Green color records then on right clicking you can add these records to another 2. workflow say = GUID this workflow is like this:

Start->Assign(here give Assignment = Assign GUID)>Stop

So in record Mode in Data Manager you can stop the workflow 1 and you can launch the workflow 2 as soon as you launched workflow 2 your values in GUID field get populated with 1234 for all the selcted records.So in this way you can assign GUID to your Duplicate records

Hope it will Help you,

Rewards if useful......

Mandeep Saini

[Former Member · Accepted solution]

Thanks Mandeep.

I have implemented the same using 1 workflow. 2 is an ideal but 1 does the job as well wherein after matching you perform assignment for all matched records. (Ofcourse yours is better that you have more control over 'what you want' matched records)

Problem comes when you say match one Vs all. In this case you have added just 1 record to the workflow. So when you execute matching you choose 1 Vs ALL. This will have 1 record in the main pane. You will never get the matched set or score here though you get matched records in pane below! So assignment will be applicabe only for this 1 record.

Hope am clear - if not feel free to ask.