Solved: Select keyid for specific column not duplicate? - Page 2

Nuttawutz · 07-06-2021 09:46 PM

If i have a table as show below.

ID	Name	Type	Qty
1	A	Pork	1
2	B	Pork	2
3	C	Milk	3
4	D	Milk	4

How should i select only not duplicate in column Type ?

If i use SELECT([Relate test][Type],True,True) , i only got list of Pork,Milk. But what i want is list of ID 1,3.

Steve

Maybe this?

SELECT(
  [Related tests][ID],
  ISBLANK(
    FILTER(
      "tests",
      AND(
        ([_ROWNUMBER] < [_THISROW-1].[_ROWNUMBER]),
        IN([ID], [_THISROW].[Related tests]),
        ([Type] = [_THISROW-1].[Type])
      )
    )
  )
)

View solution in original post