@v-siky-msft Hi, thanks for the help. Perhaps I should explain a bit more about my project. Here's a typical dataset:
4,1
4,2,2
1
4,2
1,1
2
Within this set of data, 1 would be considered unique. Even though it's contained elsewhere, the standalone '1' is a unique identifier as long as it appears by itself. (so 1 is different to 1,1 and 4,1, for example)
Likewise, 4,2 would be a unique identifier as long as it appears by itself.
What I am trying to do is use the above letter format to indicate parent/child relationships. In the set of numbers above, 4.2.2 is an ultimate child, as there is nothing below it. But 4.2 is not. Likewise, 1 is not an ultimate child, but 1.1 is. Also, 2 is an ultimate child.
<quote>
Please try with this formulas. If the countrows is 1, it means the string is unique; if the countrows is greater than 1, it means there are many of the same strings in that column.
CountRows(Search(CollectionName,"TheString","ColumnName"))
So unfortunately this does not work for the above example, because it does not consider 2 unique, as this number is found elsewhere.
<quote>
Max(Len(CollectionName.ColumnName),Result)
And then use the following formula to judge if a string length is the longest.
Len("TheString") > Max(Len(CollectionName.ColumnName),Result)</quote>
With respect to the situation I am trying to solve above, unfortunately this also does not solve the issue since it only considers whether the string is the longest of all strings contained within the collection. I need to filter the strings so that only the strings containing the current row's string are considered for length measurement.
I tried to use a filter to do this, but it kept returning table values which I therefore could not use len() to wrap around.
How do I get my syntax correct for this situation?
Thanks!
