Querying for name spelled multiple ways in 3 columns
I am new to Qlik and need to write a query in QlikView 9 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.
You would need to create a table with two columns, first column showing all possible ways to name an employee, second column the employee's official name or id, like you want it shown consistently in the data model.
You can then load this table as mapping table:
Then when loading your tables, use ApplyMap():
ApplyMap('MAP', Description1, 'No Mapping found') as NewDescription1,