Fuzzy matching of data

[ericdelaqua]

Hello,

I have this 2 incomplete datasets and I  would like to assign ids to the first dataset from the second one using hte email field.

Does Qlik provide any ability to perform fuzzy matching? I have millins of records to update and hope to use a Qlik to update some of the records.

name	address
ck,mar	chicago
asos asos	paris
p c	paris

id	Email
2345	manager@charleskmar.com
6753	asosciate@chicagoassociate.com
2831	pascal.c@pascalcarlos.com

My Expectation:

name	address	id	Email
ck,mar	chicago	2345	manager@charleskmar.com
asos asos	paris	6753	asosciate@chicagoassociate.com
p c	paris	2831	pascal.c@pascalcarlos.com

Any ideas is welcomed.

[James1997]

Hi,

You should be having atleast one same field in both to connect.

Table1:
LOAD * inline
[
name,address
ckmar,chicago
asos asos,paris
p c,paris];

Table2:
LOAD * Inline
[
id,Email
2345,manager@charleskmar.com
6753,asosciate@chicagoassociate.com
2831,pascal.c@pascalcarlos.com
];

Table3:
LOAD * inline
[
name,id
ckmar,2345
asos asos,6753
p c,2831
];
EXIT SCRIPT;

Thanks