Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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