Re: SCRAMBLE(A,B) (was UDF:Request).

2005-05-24 Thread Dan Bolser
On Mon, 11 Apr 2005 [EMAIL PROTECTED] wrote: Dan Bolser [EMAIL PROTECTED] wrote on 04/11/2005 11:50:31 AM: On Mon, 11 Apr 2005, Dan Bolser wrote: Requirement: Given two columns of a table (Column1 and Column2) of length x, return two columns (Column1_Scram and Column2_Scram) such

SCRAMBLE(A,B) (was UDF:Request).

2005-04-11 Thread Dan Bolser
Requirement: Given two columns of a table (Column1 and Column2) of length x, return two columns (Column1_Scram and Column2_Scram) such that the distributions of values in Column1 and Column2 are preserved in Column1_Scram and Column2_Scram, but the pairs of values are randomized. Solution

Re: SCRAMBLE(A,B) (was UDF:Request).

2005-04-11 Thread Dan Bolser
On Mon, 11 Apr 2005, Dan Bolser wrote: Requirement: Given two columns of a table (Column1 and Column2) of length x, return two columns (Column1_Scram and Column2_Scram) such that the distributions of values in Column1 and Column2 are preserved in Column1_Scram and Column2_Scram, but the pairs

Re: SCRAMBLE(A,B) (was UDF:Request).

2005-04-11 Thread SGreen
Dan Bolser [EMAIL PROTECTED] wrote on 04/11/2005 11:50:31 AM: On Mon, 11 Apr 2005, Dan Bolser wrote: Requirement: Given two columns of a table (Column1 and Column2) of length x, return two columns (Column1_Scram and Column2_Scram) such that the distributions of values in Column1 and