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

From table fill method

By adding a WHERE clause, you can limit the list of values used from the specified table only to those that you need. The "Preview" page allows you to view top 50 values from the linked table (or less if there are no so many unique values). These values will be used in the generation process.

So, there are settings for this fill method:

  • "Use list items as a mask" means each list value will be processed as a mask before using.
  • "Use values sequentially" option means the program will use linked table values from the first to the last. When the list ends the program starts from the first item again.
  • WHERE clause helps you to use only required values from the linked table.
  • ORDER BY clause helps you to define order of values usage. Values order is important for "Use values sequentially" mode only.
  • Format defines the view of value. This option is applicable for numeric values only.

See also: tips and solutions.