remove duplicate date

AppSheet AppSheet Q&A
1

hello everyone please i need to display records in a table. But I only need to display records that are not duplicated. This is the table I am using.
Please help me to fix the problem.

Thank you very much!

Captura de pantalla 2022-03-11 093251.png
Captura de pantalla 2022-03-11 093251.png1731×960 127 KB

2

You should be able to use something like the following to filter out the duplicates, this assumes that the ComputedKey is some sort of value which will differ from one duplicate row to another.

ISBLANK(
  FILTER(
    "my_table_name",
    AND(
      ([field1] = [_THISROW].[field1]),
      ([field2] = [_THISROW].[field2]),
      |
      |
      |
      |
      ([_ComputedKey] > [_THISROW].[_ComputedKey])
    )
  )
)
1 Like
3

thanks, I will apply what you suggested