Table with duplicate rows

[Kaiquesbezerra]

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

[dplr-rn · Accepted solution]

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

[krishna_2644 · Accepted solution]

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