Fuzzy Match

[tan_chungkam]

Hi All,

I have 2 tables which contain Short Name and Full Name.

Is there anyways to match the shortname to fullname?

Please find attached my excel files.

[Lisa_P]

It is hard to work out the relationship between these names, are there any rules to follow ?  Should they all have a match ?

[miskinmaz]

It is very much possible to map the short name with full name but for that you need to have some common association between the two.

On what basis or logic you want this to be mapped?

[tan_chungkam]

Hi @miskinmaz @Lisa_P ,

I would like have below outcome.

[Lisa_P]

You could create short name column by just selecting first name and creating new field if you like using subfield in load script.

Load FullName,

Subfield(FullName, ' ', 1) as ShortName

...

To extract first name from FullName.

[tan_chungkam]

Hi @Lisa_P ,

Thanks for the advice.

I would like to ask what if the person first name is different.

For e.g.

1. Tan Chung Kam - first name is Chung Kam

2. Sasuke Itachi - first name is Sasuke

Thus, your suggestion still can apply on this situation?

[Lisa_P]

If there is logic you can use to work it out such as:

Load FullName,

If(SubStringCount(FullName, ' ')=2, SubField(FullName, ' ',2) & ' '&Subfield(FullName, ' ', 3), Subfield(FullName, ' ', 1)) as ShortName

...