Filter slice with unique rows

AppSheet AppSheet Q&A
1

Hello experts,

I have a table with duplicates in column name and date. I need a slice to remove duplicate rows.

Table with duplicates:

Name Date
Paul 3/10/2024
Paul 3/10/2024
Paul 4/10/2024
Paul 4/10/2024
Mary 4/10/2024

I need the slice to show:

Paul 3/10/2024
Paul 4/10/2024
Mary 4/10/2024

Thanks in advance!

2

Please try a slice row filter expression of

[Key Column] =MINROW(“Table Name”, “_ROWNUMBER”, AND([Name]=[_THISROW].[Name] , [Date]=[_THISROW].[Date]))

5 Likes
3

Thank you so much!

1 Like
4

You are welcome.

1 Like