Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vincent_bellang
New Contributor III

Partial matching between primary keys

Greetings,

I have 2 tables and i want to compare their data in a sheet but their primary keys is their name but in the other table the name is longer and sometime does not contain upper case.

NameYear
Francis1995
Denis1985
Jean1975
NameAge
Francis Lalan22
denis Rousseau39

If i want to have a table like this, is there any partial matching way to do it ?

NameAgeYear
Francis221995
Denis391985
Jean1975
Community Browser