Fuzzy Match with Particular Number of Characters

[Anonymous]

Hi All,

I want some help in joinining two tables via Fuzzy match as I have being trying it from 2 days.

My dataset contains programmes examples

First Table-Programme Names

Home and Away                      

And I want to join it to second table-Series name

Home and away S2 E9

Home and away S22E9

Home and away S93 e3

Andy's baby animals

Pieces of land:The phoenix Park

An teorainn

I have used fuzzy matching and tried different threshold values from 0 till 1,this is just an example but there are lot mroe then 200 programmes which I have to connect which connects in different manner.

So when i click one table Home and away it should only show home and away title name with the series and episode name but I dont know why it is also picking up Andy's baby animals as well.

I want to know if there is any join or match which helps to connect by matching up the first 3-4 similar characters with another programmes?

[PattemManohar]

@Anonymous  Please try the Join in Power Query Editor with Threshold value as 0.5

[Anonymous]

HI Manohar,

Thanks alot but I have used different threshold values as well still its not working.

Is there anyway where I can match by using some number of characters.

Examples- first four values of programme name should match first four characters of series name?

[PattemManohar · Accepted solution]

@Anonymous  In that case, then add a new Custom column in both the tables (In Power Query Editor) as below and join based on this newly added column

=Text.Start([Data],4)