Fields are automatically associated if they have the same names. That is true. So if you code your own load script this will occur.
However, if you use the Data Manager to load and associate field they don't have to have the same names exactly. Qlik will give you options for field that seem to be the same or you can override the associations and create them manually.
I came from using QlikView first which did not have a data manager. So I coded my load scripts and did everything manually. Or you can let the data manager generate code and then unlock it and continue doing it manually. Once you unlock you can't go backwards.
Whatever you do use the Data Model Viewer to see the results of your work and to visually see how your data model is setup and working.
Okay, reading what you wrote prompted me to take another look at this. I realized my observation was incorrect that making an association in the data manager does not affect the data load editor script. I think maybe I didn't hit "Load Data" in the data manager, so the auto-generated script did not reflect the latest state of the data manager.
What really happens:
- If you DO NOT associate two tables in the data manager, the relevant fields ARE qualified with the table names in the auto-generated script, MATCHING what is shown in the data manager.
- If you DO associate the two tables in the data manager, the relevant fields ARE NOT qualified with the table names in the auto-generated script, CONTRADICTING what is shown in the data manager.
- In the script, field names must be identical to create an association. Qualifying them with table names prevents it.
- Fields that are qualified in the data manager may or may not be qualified in the auto-generated script, according to the two points above.
- If you are going to use the data manager (rather than skipping it entirely or unlocking the script it generates), you must associate the tables in the data manager via the magic wand button or drag-and-drops. There is no way to achieve the association in the data manager by giving fields identical names.