Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Qlik and need to write a query that searches 3 columns for employee name. The data is coming in from an excel download every month and the first search to be done will be to compare employee name from another spreadsheet.
The query will have to search at least 3 columns and compare employee name from another spreadsheet for confirmation that the user belongs to the correct group. A major challenge is that employee name has no continuity on the monthly download and this cannot be corrected. Employee can be identified by FName LName or LName FName, email address or user id. Another problem is that the name may be spelled incorrectly.
Example of the data to be queried:
Bill Detail | Description 1 | Description 2 |
OLVE oil | Daisy Duck | Duck, Daisy S |
Olive Oil | Popeye | Oil.Olive@WB.net |
Mouse.Mickey | Mickey M | Mickey M. |
Daisy.Duck@WWW.com | Daisy S. Duck | Sprat.Jack@WWB.com |
Mouse, Mickey | Jack Sprat | Jack Smyth |
Jck Sprat | Duck, Daisy S | Jack Smith |
Dduck | Olive Oil | Daisy S. Duke |
Jack.Smith@NBC.com | Jack Smith | Mouse, Mickey |
Mickey.Mouse@WWW.com | Jack Smyth | Dduck@WWW.com |
Thanks for your help in advance.
I think you should post the excel with some sample data if you want someone try to answer.
I guess the best advice should be to clean your source data.
hope this helps
regards
Marco
We don't own the data, it comes to us in a feed compiled from many different sources so that is not a solution for us at this time.