Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | |
2345 | manager@charleskmar.com |
6753 | asosciate@chicagoassociate.com |
2831 | pascal.c@pascalcarlos.com |
My Expectation:
name | address | id | |
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.
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