Circular Join Issue?

[devarasu07]

Hi All, stalwar1‌

How to join MinMax (Ecxcel source) into below listed tables (MaterialMaster, Shop, Fact).  the issue is here MinMax table

(ShopNo & '|' & ArticleNo  & '|' & Batch  as Primary key field)  . in the report wanted to show the Min_Stock, Max Stock value. kindly advise. Thanks

MinMax:

     ShopNo,

    ArticleNo  & '|' & Batch as ArtBatchKey,

     MIN_STOCK,

     MAX_STOCK

FROM $(vXLSPath)\excel\MinMax.xlsx  (ooxml, embedded labels, table is Sheet1);

MaterialMaster:

LOAD Barcode,

     ArticleNo,

     ArticleNo&'-'&Color_Code as Image,

     Batch,

     ArticleNo  & '|' & Batch as ArtBatchKey,    

     Color_Code,

     Color,

     Category,

     Launch,

     Brand,

     Plant

FROM $(vQVDPath)\MaterialMaster.QVD (qvd);

Shop:

LOAD StoreName,

     ShopNo,

     Country_ID,

     Country,

     Region,

     brandID,

     OutletsFlag,

     ShopCategory,

     Group,

     SubGroup

FROM $(vQVDPath)\Shops.QVD (qvd);

Fact

LOAD Barcode

     ShopNo

     Date

     SoldQty,

     TotalNetPrice

FROM $(vQVDPath)\Sales.QVD (qvd);

Regards,
Deva

[effinty2112]

Hi Deva,

Maybe :

MinMax:

LOAD

     ShopNo,

     ArticleNo  & '|' & Batch as ArtBatchKey,

     MIN_STOCK,

     MAX_STOCK

FROM $(vXLSPath)\excel\MinMax.xlsx  (ooxml, embedded labels, table is Sheet1);

MaterialMaster:

LOAD Barcode,

     ArticleNo,

     ArticleNo&'-'&Color_Code as Image,

     Batch,

ArticleNo  & '|' & Batch as ArtBatchKey,

     Color_Code,

     Color,

     Category,

     Launch,

     Brand,

     Plant

FROM $(vQVDPath)\MaterialMaster.QVD (qvd);

Shop and Fact tables look OK to me.

good luck

Andrew

[devarasu07]

Hi Adrew,

Thanks for your suggestion, tried and getting Circular join issue.

"One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. Settings for loosely coupled tables can be modified after script execution in the tables page of the document properties dialog."

Thanks,
Deva