Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Evening everyone,
I need your help as I am getting very confused with keys and associations.
I have 13 tables each of which contain the columns Year, Month & Ship.
When I loaded the data into the system, it generated a synthetic key table.
Now when I am creating graphs based on Month I am getting odd results, sometimes the Months are not ordered correctly, sometimes I am getting a new bar names ' - ' which I can get rid of if I deselect null values, but I don't have any null values in the table data.
Am I doing something wrong?
If your tables contain the same content or at least are quite familiar together then it's often the best to concatenate these tables, like:
t_match:
Load * From t1;
concatenate
Load * From t2;
concatenate
Load * From t3;
....
Commenly used are also combined keys between the tables to avoid the synthetic keys, like:
Year & '|' & Month & '|' & Ship as KEY
whereby I do not believe that those approach will be really suitable for you with 13 tables.
Many good postings about how to develop datamodels could you find here:
Get started with developing qlik datamodels.
- Marcus