Is it possible associate two tables if association reccomendation is medium/orange?

[annegedal]

Hi all,

Background:
I'm trying to associate two tables based on an ID that i know doesn't match up 100%. One table have 4701 unique IDs for cases that went through a proces and the other has 2951 IDs with quality indicators. There are some IDs in the quality related table, that have not gone through any process and therefore are not in the proces related table. 

Problem:
When i try to associate them i get a medium/orange match. However, I am unable to click the associate button! (se snapshot attached)

Question:
Is it not possible to associate unless the association reccomendation is green? If it is possible, how do i go about that?

BR,
Anne

[Channa]

fuzzy lookup or match 

[annegedal]

Thank you for the response Channa,

To my understanding the fuzzy lookup and match functions is something you would use when developing the sheets. However I'm looking to join my data in the data manager. I'm uncertain how the fuzzy lookup and match is to be applied in the data manager?

BR
Anne

[Channa]

if you have SSIS we have direct option FUZZY lookup we can build one table after FUZZy and use that in qlik

or 

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Fuzzy-Lookup-in-Table-minichart/td-p/33...

there is some help

[Channa]

xls has Fuzzy lookup , try to make in xls

you need to add from ADD-In