Can I generate two sets of data into the same table?
screek
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.
Thanks
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.
Thanks
Comments
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.