Discussion Board for collaboration related to QlikView App Development.
I have a qvd table that looks like this:
*It has about 6M records
I want to keep the record with the max(key), so I'm doing as follows:
,max(key) as maxKey
where Exists(maxKey, key)
drop table tbl1, max_key;
I expect that tblNoDup shows:
But Instead, is returning all three records. What am I missing?
add a group by to your max load
Resident tbl1 group by Id;
View solution in original post