I’m trying to find the duplicates of a list, this way I can base a special formatting rule off of it, but I’m running into the intelligence of the platform doing something I’m not wanting
Like the title says, I have the following expression results:
list(1 , 2 , 3 , 3 , 4) - list(1 , 2 , 3 , 4) = list()
- The first list has two 3s in there (that’s the duplicate I need to isolate out, and any others).
- The second list is generated FROM the first list via UNIQUE()
So I guess you could test: list(1 , 2 , 3 , 3 , 4) - UNIQUE(list(1 , 2 , 3 , 3 , 4))
I’m looking for the result: list(3) - because if I take things one-for-one that’s what I would get.
But AppSheet is an intelligent platform, and before a few months ago we didn’t have the UNIQUE() function, so (after tons and tons of bugging) the devs put in some auto-magic to make lists unique when you do any list-math on them.
But we have UNIQUE() now, so this behavior is actually a hindrance.
I was hoping that LIST() might tell the system, “Hey, take this list literally; subtract one from the other and don’t do any magic.”
But no. @Adam any suggestions? Thanks
Edit: Feature Request: DUPLICATES()??? NONUNIQUE()… THEREPEATINGONES(), DOPPELGANGERS(), CLONES()