I’m trying to get 1 single random value out column “vision labels”. I consider a single value being word(s) separate by a comma (eg.: “Dish” = 1 value, “Food” = other value). My unsuccessful attempt to achieve this in the 2 following steps:
- Converting “visions labels” column into a list format (cfr. column “list of values”).
- Isolating 1 single random value in the third column with the following formula: thisRow.list.Nth(Remainder(Random(true) * 1000, thisRow.list.Count()).RoundDown() + 1)