Hello,
I'm facing the following task - I need to be able to generate a unique sample from a table/view. A couple of notes:
These are the things I've tried/investigated:
a!localVariables( local!random: ri!min + tointeger(rand() * (ri!max - ri!min)), local!arrray: append(ri!array, local!random), if( length(union(local!arrray, local!arrray)) >= ri!count, local!arrray, rule!KS_recursion_rand_dev_selector( min: ri!min, max: ri!max, count: ri!count, array: union(local!arrray, local!arrray) ) ) )
Any suggestions? Thank you!
Discussion posts and replies are publicly visible
I suggest to implement this in a stored procedure and call it from Appian.
Do you happen to have an example of how it can be done in a stored procedure? Do you use SAMPLE() in oracle and then filter on that or?