Data Generator - pre-existing data

[Cube874]

Is it possible to populate fields in the data-generator with pre-existing data?
Some of the data has already been created and it would be much easier (and quicker) to just run a query (or better yet, call a function that I write) to retreive the correct reference value than to write and run delete/create scripts.

Running version 7.

 

[Marco Kalter]

Can you use the "List(select statement)" function for this?

 

[Cube874]

Possibly... I'll check. It might take some time. Having the Data Generator execute a query for the list would be quicker and easier for me!

 

[tadziu]

bumping this thread.
i have simmilar question, Is it possible to populate fields in the data-generator with data from another table?
the List(select statement) causes the data to be randomised and often repeat itself, i want to copy the entire column without changes (or at least without the data repeating itself)

 

[Marco Kalter]

There is no standard function for this, but you can create a SQL function for this and specify SQL(function) for the field. The function would need to return the values from the table in a predefined order. You can use the initialization script to reset the function.