Remove sync keys

[shaktisinghchau]

I have two facts and 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 attached schema in that there are too many loops, please help me optimize this data model.

[oknotsen]

The attached images does not show any Sync Keys. It does show indications of Circular References, but even for that the screenshot is too limited to figure out what your actual data model is.

In other words:

The data you are providing is too limited to try and help you and the title of your topic does not seem to have anything to do with your problem. Could you tell us more and show us more?

[idogridish2]

Hi Shakti,

you will need to build a Link Table.

See These posts:

Link Table in QlikView – Learn QlikView

or

how to create link table in Qlikview?

ido.