How can we help you today? How can we help you today?

Data fr. SQL Table with relation to a other Column

Hi I'm new to Data generator, so if this is a silly easy qurestion - sorry for that, but I can't find an answer on my own.

I have to generate data in an SQL Table that has to be very realistic.
The data are individual related. Eg. Name, Firstname, gender, street, birthdate, etc.

An example:
I have some thousand female and male firstnames in a (source) table.
1st Column: Firstname (~5000 unique in the table)
2nd Column: Gender (m / w) w == female in german.

I have to generate realistic test data, so eg. "Susanne" should'nt be "male" in the data.

Generating the firstnames is no problem.

How can I add the correct gender in the second column ??
I don't know how to refer to the same row using the second column in the source table.

Can anyone help ?

Ulrich
ULRICHS
0

Comments

2 comments

Sort by
  • James B
    Unfortunately, you can't really do this. SQL Data Generator cannot generate information in one column based on the value in another.

    It's a pretty common request, but there's no immediate likelihood of this change being made I'm afraid.
    James B
    0
  • jean-rator
    Hi,


    If you need to generate data with columns value related to other one (eg : Suzan with a 'female' data column), you could use csv Import.

    In that case, the column values are picked from an unique row.

    hope it helps...
    regards.

    JL.
    jean-rator
    0

Add comment

Please sign in to leave a comment.