Lists

Mockaroo gives you two options for generating data based on a list:


Random

The "random" options simply selects an item at random from the list when generating each row. Multiple lists that use this option operate independently. For example, imagine you have the following fields:
List random 018fe43e9234875c36ffac6cb9227bfa21aa16f582cbff209341c1b2e0f3b781
Each row will contain a random item from each lists. The data will be unordered and different each time. For example, you'd get something like:

Transaction TypeProduct
OnlineMouse
In StoreKeyboard
In StoreUSB Drive
OnlineUSB Drive
In StoreMouse
OnlineUSB Drive


Sequential

The "sequential" option steps through the list in order from start to finish and then back to the start again.
List sequential 8ac33404b437038bb52df9fde61641a5ed0ab093867c37994384a389c6f552dc
This will produce a result where both lists are iterated in order:

Transaction TypeProduct
In StoreKeyboard
OnlineMouse
In StoreUSB Drive
OnlineKeyboard
In StoreMouse
OnlineUSB Drive

Cartesian

Cartesian is similar to sequential, except that any subsequent lists that also have cartesian selectedwill be traversed in a nested fashion. For example, consider the following fields:
List cartesian 0156992b52902a9edc826dc9922723d51f9c1755155c081513712aa6d277f9fc
This will generate data in the specific order in which items appear in each list. The result is the product of all possible combinations of the two lists. Values are grouped in the order in which the lists appear in the schema:

Transaction TypeProduct
In StoreKeyboard
In StoreMouse
In StoreUSB Drive
OnlineKeyboard
OnlineMouse
OnlineUSB Drive