Datamodel issue

[shweta26]

Hi Everyone,

There are 3 tables having the same key name gcindatekey.

Table 1: gcin + mismarket + date as gcindatekey

Table 2: gcin + edsfmarket + date as gcindatekey

Table 3: gcin + edsfmarket + date as gcindatekey

Now, all markets are different.

In the Link Table, using Outer Join, we have gcindatekey, date, and market.

When we try to combine data from Table 1 and Table 2 into one straight table, data loss is happening.

[Lech_Miszkiewicz]

Hi @shweta26 

1. why are you creating composite key?
2. why dont you concatenate all 3 tables in your data model and align key fields?

That would be the easiest and will not cause any issues like you are experiencing and it will also perform better. 

I am not sure as to why would you consider creating "linking table" at all?

cheers

Lech

[shweta26]

"I can't concatenate the tables because they are all different. Some tables have seller and gcin. One table is financial, another is limits, and another is utilization, while all the other columns

• are tthe different

[Lech_Miszkiewicz]

Hi @shweta26 

What you are saying does not mean you cannot concatenate tables. It does not matter that different facts are "limits", "finance" etc... All you need to do is make sure you only align and name columns which in theory represent the same thing like for example:

• limit_date, finance_date, utilisation_date etc... as date...
• then you align all which in theory line up to the same dimension you would link in your linking table

If you are coming from non-Qlik background i understand it may be strange but for all Qlikies here this is what we do - we just concatenate different facts into single fact table and then just align common dimensions. 

The main question is whether or not you would use not common dimensions in UI as a filter or against a measures from other facts tables. That is where concatenation would only show them agains fact lines those apply to.

Cheers

Lech

[PrashantSangle]

Can you share your entire script or sample data to understand issue in more better way? Otherwise it will be just guess-work. 

regards,

Prashant Sangle