Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
How about Mapping Loads & ApplyMap()'s, maybe something like :