topic Datamodel issue in Data Quality

Datamodel issue

shweta26 — Mon, 05 Jan 2026 01:30:31 GMT

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.

Re: Datamodel issue

Lech_Miszkiewicz — Mon, 05 Jan 2026 02:00:43 GMT

Hi @shweta26

why are you creating composite key?
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

Re: Datamodel issue

shweta26 — Mon, 05 Jan 2026 02:18:43 GMT

"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

Re: Datamodel issue

Lech_Miszkiewicz — Mon, 05 Jan 2026 02:43:55 GMT

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

Re: Datamodel issue

PrashantSangle — Mon, 05 Jan 2026 03:54:11 GMT

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