Could you please advise me how to take the distinct user count(removing duplicates) in Users table using filemaker ?
thought this link may helps > Finding duplicate values
If all you want is to count the records (i.e., not necessarily create a found set), you can do this:
Let ( [
sqlQuery = "SELECT DISTINCT userID FROM users"
userList = ExecuteSQL ( sqlQuery ; "" ; "¶" )
ValueCount ( userList )
Thank you Suresh
sqlQuery = "SELECT COUNT ( DISTINCT userID) FROM users"
Does that not work?
I dunno. Does it?
Yes it does :-)
Unfortunately, COUNT(DISTINCT works but very slow if the table has many records. Not fixed yet on latest FM.
If need to count not once, make value list from the field and count ValueListItems().
Retrieving data ...