Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

datanibbler
Esteemed Contributor

lINKING two tables - use two alternative keys?

Hi,

I have two tables from two different database_systems:

- In the one (from HR), I have a first_name and name to every employee;

- In the other one I have a user_logon:

     - That is in most cases made up of 1 letter from the first_name and the name

     - In some cases, however, it is 2 letters from the first_name and the name.

Is there any way I can dynamize the use of either one of these two alternate linking_fields?

Thanks a lot!

Best regards,

DataNibbler

3 Replies
Gabriel
Valued Contributor II

Re: lINKING two tables - use two alternative keys?

Hi,

What other fields are available to both tables aside what you've listed above?.

Kindly paste this fields and which field belong to which table.


datanibbler
Esteemed Contributor

Re: lINKING two tables - use two alternative keys?

Hi Gabriel,

easy: There are none ;-)

One table is from an HR system and holds only info on the employees.

The other is from our production_database and holds no info on the employees except the logon.

I don't know yet whether and where our production_database has some master_table with all the employee_logons.

Best regards,

DataNibbler

Re: lINKING two tables - use two alternative keys?

How about Mapping Loads & ApplyMap()'s, maybe something like :

  • Applymap() in user-logon table load script with 1 letter from the first_name and the name, to return HR table employee key
  • If that find nothing then alternative Applymap() in user-logon table load script with 2 letters from the first_name and the name, to return HR table employee key


Community Browser