Refer to two facts TABLE

Question

Refer to two facts TABLE

I have two facts

I am using the following code to download from QVD

Vente:
LOAD PrixUnitaireArticle,
     PrixArticleHT,
     PrixRevientTTC,
     MargeHT,
     MargeTTC,
     ValeurRevientHT,
     ValeurRevientTTC,
     ValeurMargeHT,
     ValeurMargeTTC,
     PrixVenteHT,

FROM
E:\QVD TEST\VenteFULL.qvd
(qvd);


LOAD
  [idObjCA]
      ,[CA TTC]
      ,[VAL MRG TTC]
      ,[CA HT]
      ,[VAL MRG HT]
      ,[Rayon]
      , [Date Time Budget]
      ,[Code Site Budget]
      ,[Code Rayon]

FROM
E:\QVD TEST\Budget.qvd
(qvd)

When I load data I got the following shema, too many loops.

How can I improve my data model?

+3

qlikview

user3548593 Jul 28 At 9:54 am

source to share

1 answer

Antoine stas · Answer 1 · 2017-10-26T09:29:07+0000

You can make a link that contains all the fields that are in the double and then remove them from the original table. You have to create a key in each source table and place it in the link table.

Here's an example of a good link schema:

Refer to two facts TABLE

More articles: