Hi.
I'm experiencing an interesting challenge.
I have an API calling data that has one of the fields returning a string that has a combination of 5 random letters and 16 digits representing a UNIX time.
Some of the entries are repeated but the UNIX time itself is unique even where there is a repeated entry. However the random string makes the field unique meaning if I use the field, in the Unique filter, it returns all the values.
tqfyd1688578975095
tsdty1688578975095
abcde1688578975095
All the above are the same but the random string of letters at the beginning makes the field unique.
Is there a way to use the unique filter but return entries in the array that are unique from extracting the bit of the string that will show they are repeated? Maybe something like the below?
