Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having trouble understanding the basic principles of making a data model in Qlik Sense because what I'm seeing QS Desktop do and what I'm reading in the documentation and on the forums don't seem to match.
What I did:
What I don't understand:
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:
In conclusion:
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:
In conclusion: