lINKING two tables - use two alternative keys?

[datanibbler]

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

[Gabriel]

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]

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

[Anonymous]

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