Loop in

[Anonymous]

Hello Team,

As a new to Qlikview, need help on the implement the below scenarion.

Need to lookup from the Inline Load and update the values in the Qlikview Table Box (Value to be derived).

Below the example

Table 1		Table2:Inline Load
Lookup	Value to derived	Items	Cost
A	10	A	10
B	20	B	20
C	30	C	30
A	10
B	20
C	30
A	10
B	20
C	30

[rwunderlich]

There should be no loop required. Just load both tables with a field named Item.

QV's associative logic will automatically join the values together.

-Rob

[its_anandrjs]

Try to load this ways and rename field Items to Lookup for association

Table_1:

Load * Inline

[

Lookup, Value to derived

A, 10

B, 20

C, 30

A, 10

B, 20

C, 30

A, 10

B, 20

C, 30

];

Table2:

LOAD  Items as Lookup,Cost;

LOAD * Inline

[

Items, Cost

A, 10

B, 20

C, 30

];

[Anonymous]

Thanks verymuch

[enricohdi2]

UNQUALIFY '*';

Table_1:

Load * Inline

[

order, Lookup, Value_to_derived

1, A, 10

2, B, 20

3, C, 30

4, A, 10

5, B, 20

6, C, 30

7, A, 10

8, B, 20

9, C, 30

];

Table2:

NoConcatenate

LOAD Distinct 

Lookup as Items,

Value_to_derived as Cost

Resident Table_1;