topic Preceeding Load Problem in QlikView

Preceeding Load Problem

Wed, 09 Dec 2009 00:38:19 GMT

Im attemping to Rank DiscountAmounts from my qvd's then load only the top10 in my load script but the Rowno() is not comming through the preceeding load as im expecting.

Any idea what im doing wrong here ?


discountAmount:
Load Rank,DISCOUNT_AMOUNT Where Rank <11;
Load rowno() as Rank,DISCOUNT_AMOUNT resident Discount
Order by DISCOUNT_AMOUNT desc;
[\code]</body>

Preceeding Load Problem

Wed, 09 Dec 2009 00:56:58 GMT

Hi Colin,

I think this would work:

discountAmount:
Load rowno() as Rank,DISCOUNT_AMOUNT resident Discount

Order by DISCOUNT_AMOUNT desc;

noconcatenate

top10:

Load Rank , DISCOUNT_AMOUNT resident Where Rank <11;

drop table Discount;

drop table discountAmount;

Preceeding Load Problem

Wed, 09 Dec 2009 01:00:28 GMT

forget a reference to the correct resident table in the second load statement

discountAmount:
Load rowno() as Rank,DISCOUNT_AMOUNT resident Discount

Order by DISCOUNT_AMOUNT desc;

noconcatenate

top10:

Load Rank , DISCOUNT_AMOUNT resident discountAmount Where Rank <11;

drop table Discount;

drop table discountAmount;

Preceeding Load Problem

rwunderlich — Wed, 09 Dec 2009 02:29:55 GMT


colinr wrote:
discountAmount:
Load Rank,DISCOUNT_AMOUNT Where Rank <11;
Load rowno() as Rank,DISCOUNT_AMOUNT resident Discount
Order by DISCOUNT_AMOUNT desc;

Use recno() instead of rowno() and it should work just fine.

-Rob

Preceeding Load Problem

Wed, 09 Dec 2009 18:39:24 GMT

Cheers That sorted it