Generate Dataset with combination of two columns as unique

#1

Hello,

I have a case wherein I need to generate a dataset with all possible combinations of two columns from two datasets exactly once. For e.g.

Dataset A
A1
1
2
3
4

Dataset B
B1
1
2

|Dataset C||
|A1|B1|
|1|1|
|2|1|
|3|1|
|4|1|
|1|2|
|2|2|
|3|2|
|4|2|

The row count in Dataset A and Dataset B can vary. Is there a way to limit the record count to count(records in dataset A) * count(records in dataset B) dynamically without hardcoding #rows as 8 (in the above example)

#2

@user41 Could I ask you why you don’t want to hardcode 8 as the number of rows? With mockaroo, the number of rows is an input, not a result of a computation. So I believe this isn’t possible

#3

@user76 is correct. It’s not possible to set the number of rows dynamically in Mockaroo.