topic LOAD AND JOIN DATA ACCORDING TO FOR LOOP in QlikView

LOAD AND JOIN DATA ACCORDING TO FOR LOOP

shahafei2 — Wed, 21 Apr 2021 14:20:37 GMT

Hi all,

I've two tables that I would like to join by using for loop

the key attribute is "GROUP"

and the for loop should be based on the value in "SKUs" attribute

the expected result is to join a"factor" from "Factors" table to each "SKU" in "MD" table by as many SKUs as defiend in "SKUs" attribute according to "Group"

The tabels are:

MD:
Load SKU,
Description,
Group

from [items.xlsx]

(ooxml, embedded labels, table is Sheet1);

Factors:

Load Group,

Factor,

SKUs

From

[Factors.xlsx]

(ooxml, embedded labels, table is Sheet1);

What will be the best way to implement it?

Re: LOAD AND JOIN DATA ACCORDING TO FOR LOOP

rwunderlich — Wed, 21 Apr 2021 14:39:35 GMT

I'm not sure why you are proposing a for loop. You can join using multiple fields. From your description it sounds like a single join would do it:

Left Join(MD)
Load Group,
Factor,
SKUs as SKU
From [Factors.xlsx]
(ooxml, embedded labels, table is Sheet1);

-Rob

Re: LOAD AND JOIN DATA ACCORDING TO FOR LOOP

shahafei2 — Wed, 21 Apr 2021 14:45:39 GMT

I'm sorry if it is unclear from the description

but the SKUs attribute represents the number of SKUs that the factor is relevant for

for example, the result for the inline tables below should be :

result:

Load * Inline [

SKU,Description,Group,Factor

A,AAA,22,1.5

B,BBB,22,1.5

C,CCC,22,3

];

MD:

Load * Inline [

SKU,Description,Group

A,AAA,22

B,BBB,22

C,CCC,22

];

Factors:

Load * Inline [

Group,Factor,SKUs

22,1.5,2

22,3,1

]