Fuzzy Match with source ID

[Benji27]

Hello everyone,

I'm a little confuse about Fuzzy Match tool

In the example attached, I try to compare master data source (with LSTEAPT = 'DOWJONES') versus a 2nd source (with LSTEAPT = 'ALTIMA' )

For thtat, I have configure, Fuzzy Match tool with Merge option on LSTEAPT field

I have expected to get all ids values from DOWJONES source in the ID column, like this

ID                  ID2               MatchScore    MatchKey
38406871    15851737     100                  APS
38406871    43487372     100                  APS

But.... I have this result :(

ID                  ID2              MatchScore    MatchKey
15851737     38406871     100                 APS
38406871     43487372     100                 APS

Is it normal ? 

Or I need to configure another option ?

How can I have all id from source in only column  ID ?

Thanks a lot !

[binuacs]

@Benji27 something like this?

[Benji27]

Hello

Thanks but I expected only 2 lines as result like this

ID                 ID2               MatchScore MatchKey
38406871    15851737     100 APS
38406871     43487372    100 APS

[ArtApa · Accepted solution]

Hi @Benji27 - The problems is because of your IDs: 15851737 < 38406871 < 43487372

IDs from different Data Sources should not overlap and must be unique. Thus I suggest you to assign new IDs. For example, DOWJONES from 1 to 1,000,000 and ALTIMA from 9,000,000 to 10,000,000.

[Benji27 · Accepted solution]

@ArtApa Thanks a lot  it's works fine with sequential ID :)