Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Data:
LOAD ArcticleNr, max(versionnr) as versionnr
FROM ....source...
GROUP BY ArticleNr;
left join(Data)
LOAD ArcticleNr, versionnr, ...other fields...
FROM ...source...;