topic Re: how to joining/Mapping a table? in QlikView

Circular Join Issue?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: how to joining/Mapping a table?

effinty2112 — Fri, 07 Jul 2017 07:13:22 GMT

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

Re: how to joining/Mapping a table?

devarasu07 — Fri, 07 Jul 2017 07:44:03 GMT

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