Let proportion be based on new values only?

cb66

Hello,

I have a question regarding ProportionTables/ Proportion values: Is there a way to specify that the proportion shall be calculated on the newly generated values of the ProportionTable only?

Example:
Table A is used as ProportionTable to fill Table B, Proportion=4.
I create 1000 new random records for Table A ("RowCount=1000"), while Table A already contains 100 original records.

Desired result:
Create 4*1000 = 4000 new records for Table B.

Actual result:
SDG creates 4*(1000+100) = 4400 new records for Table B.

What can I do other than to manually calculate the Proportion factor to be 3,636363636363636?

Thanks a lot in advance & best regards!

Eddie D

Hi, thank you for your forum post.

Did you select the option 'Delete data from the table before generation'. If this option is not selected, the 100 rows of data that exist in table A before generating the 1000 new rows of data will remain so you will have 1100 rows of data in table A and not 1000 rows.

Many Thanks
Eddie

cb66

I found the simplest solution to use "RowCount" instead of "Proportion" in the first place and then calculate the required RowCount on my own.

In hindsight, the question seems a bit stupid