Generators
Generates a random address-like string. This can be applied to various parts of an address string. For example, just the street address, just the city, or a full address string. This generator can be made consistent and can be linked with another address generator to preserves the relation between the data. This way the masked data will end up producing a valid city/state/etc. pair.
The algebraic generator identifies the algebraic relationship between 3 or more numeric values (at least one non-integer) and generates new values to match. If a relationship cannot be found it defaults to the categorical generator. This generator can be linked with another algebraic generator.
Generates unique alpha numeric strings of the same length as the input. This generator can be made consistent.
Run a generator on values that match a user specified JSONPath.
This generator replaces letters with random other letters, and numbers with random other numbers; punctuation and whitespace are preserved. This generator securely masks letters and numbers, there's no way to recover the original data. This generator can be made consistent.
Generates unique alpha-numeric strings based on any printable ASCII characters. The length of the string will not be preserved. This generator can be made consistent.
A categorical generator creates values at the same frequency and values of the underlying data. This generator can be linked with another Categorical generator and can be made differentially private.
This generator replaces letters with random other letters, and numbers with random other numbers; punctuation and whitespace are preserved. This generator securely masks letters and numbers, there's no way to recover the original data. This generator can be made consistent.
Random character replacement that preserves formatting (spaces, capitalization, and punctuation). It's best if you need to preserve a join between two text columns, such as a join on a name or email. This generator can be linked with other character substitution generators.
Generates a random company name like string. This generator can be made consistent.
Apply different generators to rows conditionally based on any value in this table.
Generates a single value (based on user input) that is used to mask all values in the column.
Generates a continuous distribution using a normal distribution to fit the underlying data. This generator can be linked to other Continuous Generators to create multi-variate distributions and can be partitioned by other columns.
The cross table sum generator links columns in two tables. This column will be the sum of the values in another column. There is no preview for this generator as the sums cannot be computed until the other table is generated.
A categorical generator that selects from values you provide. This generator can be made consistent.
Truncates dates to the specific date part.
This generator scrambles characters while preserving formatting and keeping the '@', '.' This generator securely masks letters and numbers, there's no way to recover the original data. This generator can be made consistent.
Generates timestamps fitting an event distribution. Link columns to create a sequence of events across multiple columns. This generator can be partitioned by other columns.
This generator scrambles characters while preserving formatting and keeping the file extension intact. This generator securely masks letters and numbers, there's no way to recover the original data. This generator can be made consistent.
This generator replaces all instances of the find string with the replace string. If "Use regex" is enabled, use backslash ( \ ) as the escape character.
This generator can be used to generate cities, states, and zip codes that follow HIPAA guidelines for safe harbor.
Zip Codes
When generating zip codes, we examine the underlying zip code in the column and replace the last three digits with 0 unless the zip code is a low population area as designated by the current census, in which case we replace all digits in the zip code with 0.
Cities
When a zip code column has not been linked then we simply choose a random city in the United States. When a zip code has already been added to the link, however, we make sure to choose a city, at random, which has at least some overlap with the zip code.
For example, if the original city and zip code were (Atlanta, 30305) we would replace the zip code with 30300. There are many cities that contain zip codes beginning in 303 such as Atlanta, Decatur, Chamblee, Hapeville, Dunwoody, College Park, etc.). One of these cities is chosen at random so that our final value is (Chamblee, 30300), for example.
If the original zip code is designated as a low population area then we just choose a random city within the state, however, we only do this if the user has linked a State column. If they have not, we simply choose a random city anywhere in the United States.
States
HIPAA guidelines allow for information at the state level to be kept. Therefore, we passthrough these values.
Other address parts
All other address parts are generated randomly and hence there value is not influenced at all by the underlying value in the column.
Generates random host names, based on the English language. This generator can be made consistent.
Generates integer values between 0 and 2^32 - 1. Input Values must be in the range 0 to 2^31 - 1 as well. This generator can be made consistent.
Generates a random IP address formatted string. This generator can be made consistent.
Run a generator on values that match a user specified JSONPath.
Generates a random MAC address formatted string. This generator can be made consistent.
Generates a random name string that can be supplied with a number of tags to identify the type of name (First; Last; First,Last; Last,First, etc.). This generator can be made consistent.
Generates NULL values to fill the rows of the specified column.
Generates unique numeric strings of the same length as the input. This generator can be made consistent.
Default option, does not mask data.
Generates a random phone number that matches the country/region of the input phone number. This generator can be made consistent. These numbers will pass Google's libphonenumber verification
Generates a random boolean value. This generator can be linked with other random boolean generators.
Generates a random double number between the specified min and max. For this generator, the "min" is inclusive and the "max" is exclusive.
Generates a random hash string.
Returns a random integer between the specified min and max. For this generator, the "min" in inclusive and the "max" is exclusive
Generates random dates, times, and timestamps.
Generates a random new UUID string.
Uses regular expressions to parse strings and replace specified substrings with output of other generators. Parts of string to be replaced are specified inside unnamed top-level capture groups. In the case that multiple regular expressions match a given string, the first defined regular expression (and the sub-generators it specifies) will be applied.
For example, if a cell contained the string ProductId:123-BuyerId:234, it's possible to capture the substrings 123 and 234 with the regular expression ^ProductId:([0-9]{3})-BuyerId:([0-9]{3})$ - this would capture the two occurrences of three digit numbers in the pattern ProductId:xxx-BuyerId:xxx, making it possible to define a sub-generator on neither, either, or both of these captured substrings. We could also define a second broader capture, one that will match more cell values, with the regular expression ^(\w*).(\d*).(\w*).(\d*)$. This will capture pairs of words ((\w*)) and numbers ((\d*)) if there is a single character of any value between them, instead of the relatively more specific pattern of the first expression. The first expression defined (in our example, ^ProductId:([0-9]{3})-BuyerId:([0-9]{3})$) that matches the cell will have it's associated sub-generators applied, even if multiple expressions matched (and even if no sub-generators were defined on the matched expression). Defining multiple expressions allows for attaching completely different sets of sub-generators to a given cell depending on it’s value. For a reference on regular expressions in C#, see here​
Generate a column of unique integer values. Starting value is 0 and increments in increments of 1. This generator can be linked with other sequential integer generators.
Generates values of ISO 6346 compliant shipping container codes. All generated codes are in the freight category ("U"). This generator can be made consistent.
Generates a new valid Canadian Social Insurance Number that preserves formatting (non-digit characters). This generator can be made consistent.
Generates a new valid United States Social Security Number. This generator can be made consistent.
Generates unique e-mail addresses by replacing the username with a randomly generated GUID and masking the domain with a character scramble. This Generator only guarantees uniqueness if the underlying column is unique. This generator can be made consistent.
This is a substitution cipher that preserves formatting but keeps the URL scheme and top-level domain intact. This mask is not secure.
Generates UUIDs on Primary Key columns. All FK columns referencing this column will automatically have their UUID values masked as well.
Run a generator on values that match a user specified XPath
​
