Login | Register 
Products Applications Downloads Features Wiki forum Store
 

Selecting random sample from table

Still a little green? Ask your beginner's questions here

Selecting random sample from table

Postby mlantin » Wed Mar 28, 2012 12:50 pm

Is there an easy way to get a random sample of N rows from a DAT table? I was assuming some sort of sort (like the random SOP sort) but there doesn't seem to be any such thing. Before I make anything too complicated, I wondered if I was missing something obvious.

Thanks!
Maria
mlantin
 
Posts: 44
Joined: Tue Apr 14, 2009 11:10 am

Re: Selecting random sample from table

Postby keithlostracco » Wed Mar 28, 2012 1:32 pm

Could you sample a noise chop scaled to the range that you want?
keithlostracco
 
Posts: 547
Joined: Tue Dec 09, 2008 1:39 pm

Re: Selecting random sample from table

Postby selina » Wed Mar 28, 2012 1:38 pm

nothing super straight forward.. a reorder DAT to append an extra column, an eval DAT to seed that column with a random number, and then sort follow by select.

Selina
User avatar
selina
Staff
 
Posts: 369
Joined: Tue Nov 13, 2007 12:15 am


Return to Beginners

Who is online

Users browsing this forum: No registered users and 0 guests