Product Home
DTM Data Generator Online Documentation Prev Page Prev Page
General
Product Profile
Product Versions
Quick Start
Rule Wizard
System requirements
Connect to Database
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Project Properties
Program Settings
General
Interface
Rule and project
Execution
Date and Time Formats
Execution
Random BLOB Loader
Project migration
Database Model Viewer
Fill Table Rule
Table Fill Modes
Table Fill Options
Tables options
Columns options
Row count tab
Scripts
Rule Output
Preview
Fill Methods
Method Options
Random values
Values list
From table
List from file
From Values Library
Incremental
By pattern
By SQL statement
By formula
Custom generator
Named Generators
Field groups
Advanced Rules
Clear Rule
Tables Creation Options
Objects Creation
File Rule
Advanced Features
Tables Selection
Bulk project modification
Table Information
Value Library
Change target Table
Command Line
Performance Tips
Performance mode
Format Strings
Select column
Data export
How to...
Additional Info
Product Ordering
Database Utilities
Licence agreement
Demo version
Install
Uninstall
Upgrade
Support
Trademark Information
Glossary

Field Group

A group of fields is a few columns for which data is generated together. A group allows the user to work with similar fields changing generation parameters only in one place. A group consists of the first defining field and fields that depend on it.

A group is processed depending on the fill method applied to the defining field:

  1. For methods "Random", "Ignore", "By pattern", "List" and "Value Library", exactly the same methods and generation parameters that are applied to the defining field are applied to dependent fields.
  2. For methods "By SQL statement" and "List from disk file", not only the first column in the file or the result set, but also columns following it will be used. Values in these columns will be used to generate dependent fields.
  3. Such a group operation cannot be applied for methods "Incremental", "From Table" and "Expression".

To create a group, select the necessary fields and click the +G button. To delete a group, click -G button when the cursor is on the first field of the group.

Example

You have a pipe-delimited text file (coutries_with_currency.txt) with country and currency list in the following format:

Australia|Australian Dollar
Belgium|European Euro
Brazil|Brazilian Real
...

You have two fields "Country" and "Currency" in the "Countries" table. How to fill them out together:

Step Description Screenshot
1 1) Use "from file" fill method for the first (Country) column.
2) Select file with mentioned data.
3) Select pipe as column separator.
DTM Data Generator: select group definition fill method
2 Check both columns in the fields list. DTM Data Generator: select columns of the group
3 Press +G button.
The program will assign group number (see 'Group' field of the data grid).
DTM Data Generator: created group of columns
4 View results at the preview Window.
"Country" and "Currency" columns are coordinated.
DTM Data Generator: view sampple generared data for group of columns