I have a Dataset I generated (Table A) with N records. For each record in the Table A, I want to create 1-4 records in the new table (Table B). This can be generated differently every time, that does not matter. I just do not want 4 Table B records for every Table A record every time. Some Table A records will have 4 Table B records, but not every single one. Is this possible? I dont want N*4 records in table B every time, and I need the table to be varied, with some Table A records having more entries in Table B than others.
I currently just set the chance of every column in Table B to be 30%, then told my IDE to ignore all errors so it skips over the error of the fields being null when they should not be. This does do what I want, but creates other problems, like downloaded CSV having blank records as well, which in turn breaks another dataset I want to generate based on that. It would be best to get this worked out so that each record in Table B has a X% chance of not being created at all.