Tabulify - How to generate a sequence based on provided values

About

This how-to shows you how to generate a sequence based on provided values with the column sequence generator.

This page demonstrate the values and reset property of the column sequence generator.

The sequence will be created with a list of colors.

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_color–datagen.yml
• has the logical name sequence_color
• will generate 10 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_color with the varchar data type (default) that has sequence data generator that:
  • will reset (restart from the first value when the last is reached)
  • will return the color values provided in the values property.

MaxRecordCount: 10
Columns:
  - name: id
    type: integer
    comment: A id column to see easily the number of values generated
    DataGenerator:
      type: sequence
  - name: seq_color
    type: varchar
    comment: A column with a color sequence date generator
    DataGenerator:
      type: sequence
      # when the last color has been given (black), restart from the first element (blue)
      reset: true
      # the list of values returned in sequence
      values:
        - blue
        - red
        - green
        - cyan
        - magenta
        - yellow
        - black

Printing the data

With the data print command, we can print the values generated.

tabli data print sequence_color--datagen.yml@howto

id   seq_color
--   ---------
 1   blue
 2   red
 3   green
 4   cyan
 5   magenta
 6   yellow
 7   black
 8   blue
 9   red
10   green

Next

Because a generator is just a data resource, you can use it in every data operation.

How to use a generator in a data operation