Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Match entries of two fields

Hi,

I have 2 table with two name fields : 

Table1:

id  Name

1  Tom J Hanks

2  Ben Alan Franklin

3 Anne Marie-Jean Hawk

4 Justin Rodriguez

 

Table2:

Name_entered

Tom Hanks

B. Franklin

Anne H

Justin Rod

 

Entries in table2 do not contain the entire name. I need a way to match the names of table2 with table1 with the most accuracy possible.

Labels (2)
2 Replies
Highlighted
Digital Support
Digital Support

Try the following Design Blog post as well, may be of some use:

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.