When I do a lookup in a dataset it returns a number of results. I want to randomly pick from the results set and not just the first match.
Example - look up Red and I would like have one of the three values (89,43,77) be returned. Right now I get the first match of 89 every time.
Color|Value
Blue|17
Red|89
White|19
Red|43
Black|89
Red|77