What I am about to describe is a situation where I want to generate a fixed number of records based on a combination of 1 or more columns. That is, if column A has 5 unique values and column B has 2 unique values, I want 10 records with all possible combinations.
The other part of this problem is that I need to be able to generate date values which iterate sequentially (not randomly).
I am trying to create data for the following scenario. Imagine a call center where there are 5 operators and I want to create data for each operator for 2 sequential days. I want 10 records as follows:
Date Operator ID
3/1/2017 1
3/1/2017 2
3/1/2017 3
3/1/2017 4
3/1/2017 5
3/2/2017 1
3/2/2017 2
3/2/2017 3
3/2/2017 4
3/2/2017 5
Using a custom list, I know that I can specify values 1,2,3,4,5 and tell Mockaroo to generate data sequentially. And I can create a date field with a date range of 3/1/2017 and 3/2/2017. However, if I generate 10 records I will get duplicate Operator / date combinations. e.g.,
3/1/2017 1
3/2/2017 2
3/1/2017 3
3/1/2017 4
3/1/2017 5
3/2/2017 1
3/1/2017 2
3/2/2017 3
3/1/2017 4
3/2/2017 5
Perhaps I could solve this with a dataset with the 10 unique combinations that I want…but it would be nice if there was an easier solution. Thanks!