Places today’s timestamp in the column for each row. This option is relevant only for the Date or Time formats.
Inserts sequential data based on the parameters that you specify. See Numeric or Character Sequence Data.
Suppose that there are n rows and that the three proportions are p1, p2, and p3. The values are generated as follows:
–
|
The rows corresponding to the smallest Round(np1) random uniform values are assigned the first value, the rows corresponding to the next smallest Round(np2) random uniform values are assigned the second value, and the remaining rows are assigned the third value.
|
1.
|
2.
|
3.
|
4.
|
In the Step box, assign the sequence.
|
5.
|
(Optional) In the Repeat each value N times box, enter the number of times that you want each numeric value repeated.
|
6.
|
Click OK.
|
For example, if you want the column to contain even numbers from 2 to 60, type 2 in the From box, 60 in the To box, and 2 in the Step box.
1.
|
2.
|
3.
|
4.
|
(Optional) In the Repeat each value N times box, enter the number of times that you want each character value repeated.
|
5.
|
Click OK.
|