Weighted List

The simplest way to populate your database with test data.

Weighted List

Postby imranmerchant » Thu Jan 28, 2010 2: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?

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

Postby Linda Hawksworth » Mon Feb 01, 2010 3: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 10:32 am

Postby almasmith » Wed Feb 03, 2010 6: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:

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

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests