256129_en-US

liliconcom

Initializing unique number of rows for each column

Hello,

I am generating random normal distributions with different mean and sigmas for each row. 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 row or any other way to control that. 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

Re: Initializing unique number of rows for each column

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 )
)