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.
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 ?