How to generate a sequence of letters


This how-to shows you how to generate an string,varchar, text sequence with the column sequence generator.


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_varchar–datagen.yml
  • has the logical name sequence_varchar
  • will generate 30 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_char with the varchar data type that has sequence data generator
MaxRecordCount: 30
  - name: id
    type: integer
    comment: A id column to see easily the number of values generated
      type: sequence
  - name: seq_char
    type: varchar
    precision: 2
    comment: A column with a sequence character generator
      type: sequence

Printing the data

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

tabli data print sequence_varchar--datagen.yml@howto

howto is the connection that contains the files used in the HowTo's.

id   seq_char
--   --------
 1   a
 2   b
 3   c
 4   d
 5   e
 6   f
 7   g
 8   h
 9   i
10   j
11   k
12   l
13   m
14   n
15   o
16   p
17   q
18   r
19   s
20   t
21   u
22   v
23   w
24   x
25   y
26   z
27   ba
28   bb
29   bc
30   bd


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

Related Pages
Undraw Data Processing
How to generate data with the Tabulify Data Generator

A collection of how-to's to get the in and out of the Tabulify Data Generator
Undraw Data Processing
Sequence Generator

A sequence generator is a column data generator that generates a sequence 1,2,3, ... a, b, c, ... 2011-11-10, 2011-11-09, ... blue, red, ... When a tick happens the sequence is going...

Task Runner