Choose Language Hide Translation Bar
Highlighted
SK12
Level I

Initializing unique number of rows for each column

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

1 REPLY 1
Highlighted
txnelson
Super User

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 )
)
Jim
Article Labels

    There are no labels assigned to this post.