Initializing unique number of rows for each column

SK12

Hello,

I am generating random normal distributions with different mean and sigmas for each column. I would like each column to have the number of rows matching the required sample size of the distribution but I haven't been able to find a way to make this happen. I am looking for a script where I can initialize specific number of rows (= required sample size) for each column or any other way to control the total number of randomly generated values in each column.

I prefer to not delete extra/unwanted rows after generating the random numbers.

 

Any help would be greatly appreciated!

PS: I am currently generating a different file for each dataset then combining them and its very time consuming!

 

BR,

SK

txnelson

Here is a formula to only generate 10 rows of random numbers regardless of the number of rows greater than 10 the data table has

If( Row() <= 10,
	Random Normal( mu = 100, sigma = 10 )
)