Handle two fact TABLE

Question

I have two facts

I use the following code to load 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 , there are too many loops .

How can I improve my data model ?

First, show all your scheme, not part of it, to get a better idea of how to help you....for example -- do you have any sync tables? Second, try renaming one of the link fields. Third, maybe a Link Table is a good Idea here?... — EldadT, Jul 28 '15 at 18:31
Also, see [this question](http://stackoverflow.com/questions/18337272/handling-multiple-fact-tables-in-qlikview). I think if you follow the steps in my answer to that question, your problem will go away. — bdiamante, Jul 29 '15 at 15:06

score 2 · Accepted Answer · answered Oct 26 '17 at 09:29

2

You can make a linktable which contains all the fields that are in double and then remove it from the source table. You have to create key in each source table and put it in the linktable.

Here a example of a good linktable schema:

answered Oct 26 '17 at 09:29

Antoine Stas

229
1
12

Handle two fact TABLE

1 Answers1