several version of order, load last one

[#1]

Hi guys,

I have several version of some orders,

like:

Version 1: inquiry

version 2: passing

version 3: delivery

... ->versionnr

so, my  intention is to get the last version.

there is a key: ArticleNr, and others like description, amount, ...

so, how can I tell in script, that Qlikview only import the lastes version of each Articlenr?

like:

Load ArticleNr where MaxString(versionr),

     description, amount ...

I hope you can understand this

[Gysbert_Wassenaar]

Data:

LOAD ArcticleNr, max(versionnr) as versionnr

FROM ....source...

GROUP BY ArticleNr;

left join(Data)

LOAD ArcticleNr, versionnr, ...other fields...

FROM ...source...;