In my data load editor, I have 3 sections with each section having a different dataset.
1. Dataset one has 5 fields
2. Dataset two has 14 fields
3. Dataset three has 7 fields
There is one field in each of these datasets that is the same so in my data model viewer this field connects the 3 together.
What I need in order to put the visuals that I want together, is for all the fields to connect i.e as if the data was loaded as one file.
It is not possible for me to merge these outside of qliksense and then just upload. It is something that I need to do in the load script as the datasets come from different sources.
Is this something that can be done, and if so how can I do this (with an example) please?
as @vinieme12 mentioned you can use concatenate. to create 1 table. what you can also do is use a join.
there are multiple joins you can do (left, right, inner, outer joins) to also create 1 table.
I need to say, watch out with joins. you have 1 fieldname in commen with all the 3 tables you load in. but are they key fields? r is there contant the same? is not then use concatenate instead.
why be cautious with joins?
Joins are great but they can lead to unexpected big (exploded) tables (you won't be the first or last to crash a server or Qlik Desktop) with a bad join.
