A function that can work with both multi-string and Table input is Join. It allows the user to take the list of strings and build one string from it, connecting the values with a provided separator. Let’s take the example of ResponseLabels - users probably won’t know on which position in ResponseLabels is the specific label that is needed. We can get a sneak peak into the underlying multi-string by joining it into one string, e.g., with a comma as a separator.
Based on that, we know that the year label, which is what we are interested in, is in the second position and we can use ItemAt to retrieve it.
When used with a Table, Join provides a string which joins all the labels from the input Table by default. It is possible to change this to id or value by providing additional property, but default behavior should be the most common scenario here. See how we can get a list of all makes separated by comma based on a Table we created.
Earlier, We retrieved the best item from a sorted list using the ItemAt function. However, sometimes, multiple items with the same top score exist, especially if scores are rounded. In this case, we need to get all items with the top score, not just one.
To do this:
1. Use the Filter function to select only the rows where the rounded score equals the highest rounded score in the table (let's assume we round to whole numbers).
2. Once we have this list, use the Join function to combine these items into a single string.
