Weighted List

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Weighted List

Postby imranmerchant » Thu Jan 28, 2010 3:29 pm

Dear All,

I m using weighted list in one column named as 'Value' & i have give 10 items in list with 10% each & i m generating a 10 records in this table but after generation it still duplicate the list item rather than showing it once.

ANy suggestion?


Regards,
Imran Merchant
imranmerchant
 
Posts: 1
Joined: Sat Jan 16, 2010 2:17 pm

Postby Linda Hawksworth » Mon Feb 01, 2010 4:49 pm

I have sent you a PM requesting a screenshot of your settings to try and reproduce the behaviour you are seeing.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Postby almasmith » Wed Feb 03, 2010 7:12 pm

There is no guarantee that items in a weighted list will be unique. In your situation (all items weighted the same) they all have an equal chance of being generated for each row. Meaning that even if a value has been used it still has a chance to show up again.

Weighted lists do not have the "Set Unique" option.

I would suggest using the Regular Expression generator as follows:

Check the "Set Unique" box
Uncheck the "Allow null values" box
In the text area for the regular expression type your values in parenthesis separated with pipes like so:
(Value1|Value2|Value3|Value4|Value5|Value6|Value7|Value8|Value9|Value10)

That should do the trick.
almasmith
 
Posts: 7
Joined: Tue Jan 26, 2010 10:55 pm


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests