Product Home
DTM Data Generator Online Documentation
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Execution
Fill Table
Table Fill Modes
Table Fill Options
Row count management
Fill Methods
Method options
Random values
Values list
From table
List from file
From Values Library
Incremental
By mask
By SQL statement
By formula
Field groups
Data Preview
Table Information
Advanced
Data Rule Properties
Project Properties
Tables Selection
Program Settings
File Structure
Values Library
Clear Rule
Project migration
Command Line
Performance Tips
Schema Viewer
Format Strings
Tables Creation Options
Select column
Objects Creation
Data export
How to...
Tools
Random BLOB Loader
Values Library Builder
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Glossary

Incremental method

For the incremental method of filling, it is possible to specify the initial value and how many times each value should be used. For example, if you specify 3 as the initial value and 2 in the "times" field, you will get the following sequence:3,3,4,4,5,5... Moreover, you can specify step value and format of generated value output.
For the incremental method there is an additional option allowing you to specify that the sequence will be started from the next value after that already existing in the database. In this case the program calculates the maximum column value, increases this value by one and uses this new value to start the sequence.

There are settings for this fill method:

  • "Insert after last" means the program will find maximum existing value of the column and generate values greater it. Otherwise, the program will use "Starting with" value specified by user.
  • "Step" property will be added to current value at each step. Negative values are acceptable for this parameter.
  • Format defines the view of value. This option is applicable for numeric values only.
  • "Use each value" property defines how many times each value will be used by the data generator.
  • For date and time values step type (hour, day, minute, etc.) can be specified.

Example: for "Starting with" is 5, "Step" is 3 and "Use each value" is 2 and format "%03d" the following sequence will be generated: 005,005,008,008,011,011,...