topic What Join? in QlikView

What Join?

Thu, 25 Jun 2009 19:19:04 GMT

Hello at All,

in this case:

Load * Inline [
item, remaining qty
AAA, 100
BBB, 200
BBB, 90
];

Load * Inline [
item , Cost
AAA, 10
BBB,30
BBB , 10
];

What is the Join I have to use to abtain:

AAA 100 10
BBB 290 100

Thank

Best Regards s.

Slash [:)]

Re. :What Join?

Thu, 25 Jun 2009 19:43:20 GMT

The answer is : Magic Join, because you can't have BBB 290 100, but BBB 290 40 !

Here's the real answer :

First_Table:
Load * Inline [
item, remaining qty
AAA, 100
BBB, 200
BBB, 90
];

Second_Table:
Load * Inline [
item , Cost
AAA, 10
BBB,30
BBB , 10
];

Third_Table:
Load item as Item, sum([remaining qty]) as Quantity
Resident First_Table
group by item;
Join Load item as Item, sum(Cost) as COST Resident Second_Table
group by item;

Hope this helps...