Hi, I met this problem. I connect thru ODBC to the data source and load 3 tables from Pervasive SQL. I have a proper ODBC driver. When I import data to the new Qlik document, Qlik makes connections between tables and use field names for that.
For example: I have two tables Employees and Departments. In both I have the field "Address" and in Employees field "ID_employee" and in Departments "ID_empl". Qlik makes connection using "Address", but I need to use "ID_employee" and "ID_empl". I use "ID_empl" as "ID_employee" in data input script now, but it is a workaround I think.
Can I change this? For example to set in Qlik that key is not "Address" but those two IDs.