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

Generate Only One Column

MironMiron Posts: 2
How can I generate only one column in a table.
I want to generate a weight list values based on ID's from other table


  • Options
    Hi Miron.

    To generate data in just one column, you would highlight the table on the left hand side, then pick "Use existing data source" and point it at the table containing the data you want to keep in another DB.
    Then, for each column, you can pick the source data to keep from the top of the "Generator" dropdown list, apart from the column you want random data for. For that column, just pick the generator you want.

    The issue I think you will have is that the Weighted List generator doesn't allow you to base it on information from other columns/data - it only works with the data you put into the generator.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.