Discussion Board for collaboration on QlikView Scripting.
I have 2 Sources
I want to have a clear table with distinct keynr, becaus in S2 (archieved) are some Keynr from S1 ..
and in S2 are many Versions of Keynr2s.. so I need only the lastest Version of each Keynr2
So I've tried:
Load Keynr1, Date
Resident All Where not exists(Keynr2)
Load Keynr2,Date,max(Versionnr) as Versionnr
Resident All Where exists(Keynr1) and exists(Keynr2) Group by Keynr2, Date, Versionnr;
Load Keynr2 as Keynr3, Date, Max(Versionnr) as Versionnr
Resident All Where not exists(Keynr1) group by Keynr2, Date, Versionr;
Is that right?
I dont get the 2. table (1&2only)..
can you explain me, and tell me how to filter that ?
can u try this way,
Load Keynr1 as Keynr1,
'' as Versionnr,
Load Keynr2 as Keynr,
Something like this:
Max(Versionnr) As MaxVer
Group By Keynr2;
LOAD KeyNr2 As Keynr1,
MaxVer As Versionnr,
Where Not Exists(Keynr1, Keynr2)
And Versionnr = MaxVer;
Why do you want S2 Join with S2?