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

Controlling the distribution of generated data

HI
Is there any means by which we can control the distribution of generated test data.

i.e I have a 'VISIT' table with a column name 'VISIT TYPE' [with any one of three types of input data 'Inpatient','Outpatient' or 'Emergency'], so i would like to generate the data in such a manner that 60% of the generated data should be 'Inpatient', 20% should be 'Outpatient' and 20% should be 'Emergency'.[If we are generating 100 rows for visit table then 'VisitType' column should contain 60-Inpatient , 20-Outpatient,20-Emergency data rows]

Regards,
Ranjeet
ranjeet
0

Comments

5 comments

Sort by
  • James B
    There is a "weighted list" generator under "Generics" that may do what you want.

    You could add the values as:

    Inpatient 6
    Outpatient 2
    Emergency 2
    James B
    0
  • ranjeet
    Hi
    Thanks for the reply.I tried to generate the data with the "Weighted List" as you mentioned.But it is not generating exact number of rows

    for eg: When I tried to generate 100 rows .it will generate 55 -Inpatient,25-Outpatient and 15-Emergency.
    If i generate only 10 rows then it will generate 7-Inpatient , 3-Outpatient and it will not generate any Emergency values.


    Regards,
    Ranjeet.
    ranjeet
    0
  • James B
    You could try specifying the figures as percentages - i.e. 60,20,20. Does that help? If not, I'll probably need to raise a bug for it not working quite correctly.
    James B
    0
  • ranjeet
    Hi
    I tried with 60%,20%,20% and it is generating 'Inpatient-55','Outpatient-25'and 'Emergency-20' and my seed value is 3068.If you need any info please let me know.

    Regards,
    Ranjeet
    ranjeet
    0
  • James B
    I've tested this out some more and it does seem to be not working correctly.

    I've raised a bug (SDG-945) for this to get looked at; although I'm not sure when this will be unfortunately.
    James B
    0

Add comment

Please sign in to leave a comment.