topic find top sequence number per row in QVD in QlikView

find top sequence number per row in QVD

Thu, 13 Oct 2011 23:42:12 GMT

My source qvds have a descending sequence that determines the latest version of the row, for example:

5,a
4,a
3,a
2,a
1,a
4,b
3,b
2,b
1,b
3,c
2,c
1,c
1,d
2,e
1,e

would result in

5,a
4,b
3,c
1,d

2,e

How would I limit the input data to show the current values from the qvd?

James

Re: find top sequence number per row in QVD

gussfish — Fri, 14 Oct 2011 00:29:29 GMT

This would do the trick.

RawData:

LOAD

RecNo() as RecNo,

Number,

Letter

FROM source.csv (txt);

LatestNumberLetters:

LOAD

Number,

Max(RecNo) AS RecNo

Resident RawData;

LEFT JOIN

LOAD

RecNo,

Letter

Resident RawData;

DROP Table RawData;

DROP Field RecNo;

find top sequence number per row in QVD

Tue, 18 Oct 2011 13:45:19 GMT

I worked on this for the past couple of days and found that while the question and answer were helpful, the original problem was solved by reading a control record from the database. Seems I should have done a bit more research on the problem before asking my question.

thanks,
James