What is a Lookup?

Previous  Top  Next

A "lookup" in the Advanced Data Generator is a set of data with 1 or more columns and 1 or more rows. You can use this set of data in your project to generate, for example:

multi-column referential links (How to)
import CSV files
use data from an external data source
use the result from a custom aggregate query to generate new values


and much more...


What types of lookups are there?

With a lookup, you can get data from:

database tables in the current database or from another registered database
database views in the current database or from another registered database
custom SQL queries in the current data or in another registered database
CSV Files


How does it work?

When you use a Lookup to generate data, the data is loaded into memory and when you get data from multiple columns, it makes sure that this data always comes from the same row.


A Lookup has one of three "select-modes" of data:


Take a random row per iteration and use it's column values.


Start at row 1 and move to the next row after each iteration. Optionally "wrap around" to row 1 at the end of the set of data.


Take a random row and remove it from the list of possible rows to take, so that each row is only used once.


Creating a lookup

You can create lookups for each item in the database tree view. Click tab Lookups under Item Settings and use the Define Lookup button.


Lookups in the Data Generator Project window


This will start the Define Lookup Wizard, select a lookup-type and click Next. Now enter the details for database based lookups or the CSV file lookups.