What are the challenges you face when working across database platforms? Take the survey

Can I generate two sets of data into the same table?

screekscreek Posts: 5
Is it possible to generate two (or more) sets of data into the same table?

For example, I have generated a table of "Persons" and a table of "Organisations". Now I want to generate a table of "Addresses" which sources data from both the "Persons" and the "Organisations" tables (so that there is one address record for every person and every organisation)

Is this possible?

I tried about setting a a view across both parent tables and sourcing from that but the generation does not seem to occur in the right order and the Addresses tables ends up blank.



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Stephen,

    In the current version of Data Generator, you cannot generate the data in one column based upon SQL Data Generator-generated data in another column. It works only with existing data. This could be addressed in a future version.
Sign In or Register to comment.