topic Table with duplicate rows in QlikView

Table with duplicate rows

Kaiquesbezerra — Sat, 16 Nov 2024 20:57:37 GMT

Good afternoon, dear, how are you?

In my QlikView table, the data is appearing duplicity, would you have any way to bring just the line that has the latest date?

Here's an example image of how my table is

Thanks hugs

Re: Table with duplicate rows

dplr-rn — Tue, 30 Apr 2019 18:54:39 GMT

Whats a reliable identifier for that table?
what you need to do is after load your table.
resident load another one and do an inner join
e.g.
inner join (YourTable)
load
ID,
Max(Date) as Date
resident YourTable

Re: Table with duplicate rows

Qrishna — Tue, 30 Apr 2019 19:19:42 GMT

Use Firtsortedvalue() or Max() function to find the latest Dt.