Benchmark Factory for Database 8.0 - User Guide

Randomly selects multiple strings based on probabilities from a list.  If Weight is omitted, a value of 100 is assumed. The probability that any string is include in the returned value is determined by the value of nWeight. Each string included in the return value is separated by a comma.

string1-The first string in a list to return.

nWeight1-Positive integer indicating the relative weight of the first string. Probability should be expressed as a value between 0 and 100.  

string2-The second string in a list to return.

nWeight2-Positive integer indicating the relative weight of the second string.  Probability should be expressed as a value between 0 and 100.  

stringN-The last string in a list to return.

nWeightN-Positive integer indicating the relative weight of the last string.  Probability should be expressed as a value between 0 and 100.  

$BFRandMultiList(string1[:nWeight1], string2[:nWeight 2], …, stringN"[: nWeightN])

$BFRandMultiList("Red", "White":50, "Blue":25) ;

returns a value that always contains Red, contained White 50% of the transactions, and Blue 25% of the transactions.