About
This how-to shows you how to generate an integer sequence (1,2,3,…) with the column sequence generator.
Steps
Creation of the generator file
To generate data, you need to create a generator file that will describe the data to be generated.
The below data resource generator:
- has the name sequence_number–datagen.yml
- has the logical name sequence_number
- will generate 14 values (MaxRecordCount count)
- has a column named id that has sequence data generator that:
- starts by default at the value 1
- increments by default with the value 1
- has a column named seq_int with the integer data type that has sequence data generator that:
- start with the value 3
- increments every 2 digits (the step value)
- generates 5 values (the maxTick value)
- has a column named seq_float with the float data type that has sequence data generator that:
- start with the value 1 (default)
- increments every 0.5 digits (the step value)
MaxRecordCount: 14
Columns:
- name: id
type: integer
comment: A id column to see easily the number of values generated
DataGenerator:
type: sequence
- name: seq_int
type: integer
comment: A column with a complex sequence integer generator
DataGenerator:
type: sequence
start: 3
step: 2
maxTick: 5
- name: seq_float
type: float
comment: A column with a float sequence generator
DataGenerator:
type: sequence
step: 0.5
- name: seq_double
type: double
comment: A column with a double sequence generator
DataGenerator:
type: sequence
start: 10
step: 0.75
- name: seq_numeric
scale: 2
type: numeric
comment: A column with a numeric sequence generator
DataGenerator:
type: sequence
start: 3
step: 0.255
- name: seq_decimal
scale: 2
type: decimal
comment: A column with a decimal sequence generator
DataGenerator:
type: sequence
start: 3
step: 0.255
Printing the data
With the data print command, we can print the 14 values generated.
tabli data print sequence_number--datagen.yml@howto
id seq_int seq_float seq_double seq_numeric seq_decimal
-- ------- --------- ---------- ----------- -----------
1 3 1.0 10.0 3.00 3.00
2 5 1.5 10.75 3.26 3.26
3 7 2.0 11.5 3.51 3.51
4 9 2.5 12.25 3.77 3.77
5 11 3.0 13.0 4.02 4.02
Next
Because a generator is just a data resource, you can use it in every data operation.