Discussion Board for collaboration on QlikView Scripting.
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!
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.
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.
How about Mapping Loads & ApplyMap()'s, maybe something like :