Duplicate Records

[Former Member]

Hi

I have imported the first file using import manager.

and i have connected the second file. i find 2 entries are repeated.

i want to import other records and skip the similar ones. but i am not able to do that. i have selected the necessary default import actions. but the icon <b>execute import</b> is in disabled state.

Pls help me.

i want to import the second file, by creating entries which doesnt exist. pls let me know any right procedure.

i know that two entries are duplicate. what are my next steps? where and how do i create IDs for the duplicate records...? kinldy help me...

thx

pavan

[Former Member · Accepted solution]

Hi Pavan,

In Import Manager under <b>"Match Records"</b> tab just check if both the files have same "<b>Matching Fields</b>".

If you want to use the same Matching Field then perform <b>"Value mapping" in "Map Fields\Values"</b> Tab for new values if required so that Import Manager can compare existing destination records with the incoming records on different fields and provide appropriate "Import Actions" .

After every step check <b>"Action Items" In "Import Status" </b>tab and perform necessary steps specified in "Action Items".

When these "Action Items" reflect <b>"Ready for Import" </b>only then the "execute Import" will be enabled.

Please revert if any queries.

Thanks and Regards,

<b>Sagar Sonje.

Mark Helpful Answers</b>

[Former Member · Accepted solution]

Hi Sagar,

Thanks for your reply. I did not do the value mapping. Once i finished, I could get the <b>execute import</b> icon enabled.

now i have two rows as duplicate.

could you pls suggest me the procedure to create the ID... i mean the next steps pls...

thx

pavan

[Former Member · Accepted solution]

Hi Pavan,

Now once Data is imported in Repository and still there are duplicates then you have to eliminate these duplicates using Data Manager's Matching Mode.

Matching Mode is used to find and merge duplicates.This can be done in following steps:

Step1. In Data Manager go to Matching Mode and Select Transformation tab.Right click in Transformations pane and select Add Transformation then go to Properties pane and select the field you want to transform.Do the proper substitution in substitution pane example: Suppose that there are two values <b>Pavan.</b> and <b>Pavan</b> due to the "." MDM will interpret them as different values but they are duplicates so to eliminate this problem you can use substitution. So specify ".' in From and Blank space in To .Create similar transformation for other fields as well.

Step2. Go to Rules tab and Right click in Rules pane and select Add Rules then go to Properties pane and select the transformed field i.e.[XFM] .

Specify the scores for success failure and undefined properties as per your requirement.Create similar rules for other fields as well.

Step3. Go to Strategies tab. and Right click in Strategies pane and select Add strategies In the Rules Pane select the rules you want to include in the Strategy.Min Score and Max Score are calculated automatically. It is the sum of all individual matching rules in this strategy. Low Threshold and High Threshold classify the matching results and must be set manually. They decide the Match Class for a record upon executing the strategy.

Step4. Go to the Records Pane and to execute the matching, select one or more records from the record set and right-click. Select Match Records from the context menu and select the relevant matching type:

• Selected vs. Selected matches the selected records with each other

• Selected vs. Results matches the selected records with the record set derived from the search criteria

• Selected vs. All matches the selected records with all records in the repository

• Results vs. Results matches all records that result from the search criteria

• Results vs. All matches all records that result from the search criteria with the records in the repository

Step5. On the basis of the Score select the record and See the corresponding matched records in the Matches tab and include the records you want to merge.

Step6. Go to Merge tab and for the selected matched records select the appropriate values and then right click in the bottom pane and select merge records. So the selected records are now existing as a new single merged record.

Try this out and let me know.

Thanks and Regards,

<b>Sagar Sonje

Mark Helpful Answers

</b>