Red Gate forums :: View topic - Weighted List
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Weighted List

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
imranmerchant



Joined: 16 Jan 2010
Posts: 1

PostPosted: Thu Jan 28, 2010 3:29 pm    Post subject: Weighted List Reply with quote

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
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Mon Feb 01, 2010 4:49 pm    Post subject: Reply with quote

I have sent you a PM requesting a screenshot of your settings to try and reproduce the behaviour you are seeing.
Back to top
View user's profile Send private message
almasmith



Joined: 26 Jan 2010
Posts: 7

PostPosted: Wed Feb 03, 2010 7:12 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group