Data Generation Function List
Search Knowledge Base by Keyword
The data generation functions are categorised logically, making it easier to browse them and find them. They can be used as simple functions, or combined in complex formulae.
Note: for some functions, the cell type must be set. For instance, generating dates requires the cell formatting must be set to the relevant date type. To format cells, right click the relevant cells and click “format cells”, before selecting the relevant formatting. Cell formatting further provides a greater degree of flexibility and increases the variety of data that can be generated using the data generation functions. The formatting can be specified for some functions within the formula itself, as specified below.
Note: The locale is set to the default US English (en_US) in the following examples, unless otherwise stated.
General functions
Function Name | Description | Example |
---|---|---|
DataGen.FormattedString | Returns a random string, using the format “# = Number, ? = Letter, * = Number or Letter”. | =DataGen.FormattedString("# = 3, ? = A, * = 5") Returns: 2 = 3, C = A, 7 = 5 6 = 3, L = A, 9 = 5 1 = 3, Q = A, 2 = 5 |
DataGen.Random.RandomFromCSV | Returns a random value from a list of specified values. | =DataGen.Random.RandomFromCSV("Red,Yellow,Green,Blue") Returns: Red Yellow Red |
DataGen.SetLocale | Sets the Locale. | =DataGen.SetLocale("sv") Returns: Locale is set to sv |
DataGen.SetSeed | Sets the Seed. | =DataGen.SetSeed(2) Returns: Seed is set to 2 |
Numbers
Functions for generating integers and decimals.
Function Name | Description | Example |
---|---|---|
DataGen.Random.RandomDouble | Returns a random double variable less than 1. | =DataGen.Random.RandomDouble() Returns: 0.291310112 0.634659199 0.968867593 |
DataGen.Random.RandomInt | Returns a random integer value within a defined range. The function is formatted =DataGen.SequenceInt(minValue, maxValue). | =DataGen.Random.RandomInt(1, 6) Returns: 6 2 6 |
DataGen.Random.RandomLong | Returns a random big integer value within specified long range. The function is formatted =DataGen.Random.RandomLong(minValue, maxValue). | =DataGen.Random.RandomLong(1,50000)
Returns: 229432 33478 8765 |
DataGen.SequenceInt | Returns a random integer from a defined starting point, without duplicate values. The function is formatted =DataGen.SequenceInt(sequence name, starting number). Integers will not duplicate within each given sequence name. | =DataGen.SequenceInt(1, 1)
Returns: 1 2 3 |
Addresses
Functions that generate names and postal addresses.
Function Name | Description | Example |
---|---|---|
DataGen.Address.BuildingNumber | Returns a random building number between 3 and 5 characters for an address. | =DataGen.Address.BuildingNumber()
Returns: 076 4583 5567 |
DataGen.Address.CityPrefix | Returns a random city prefix. | =DataGen.Address.CityPrefix()
Returns: East Port Lake |
DataGen.Address.CitySuffix | Returns a random city suffix. | =DataGen.Address.CitySuffix()
Returns: Shire Berg Ham |
DataGen.Address.Country | Returns a random country. | =DataGen.Address.Country()
Returns: Barbados Fiji England |
DataGen.Address.CountryCode | Returns a random country code. | =DataGen.Address.CountryCode() Returns: QA JP SM |
DataGen.Address.County | Returns a random English county. | =DataGen.Address.County()
Returns: Cambridgeshire Buckinghamshire Nottinghamshire |
DataGen.Address.FullAddress | Returns a random full address. | =DataGen.Address.FullAddress() Returns: 71186 Eichmann Gateway, North Nayelishire, India 381 Emelie Ports, Schultzport, Nigeria 935 Mertz Spurs, Lake Ignacio, Niger |
DataGen.Address.Latitude | Returns a random latitude. | =DataGen.Address.Latitude() Returns: 61.9834 -69.9603 -64.8166 |
DataGen.Address.Longitude | Returns a random longitude. | =DataGen.Address.Longitude() Returns: -84.5083 -8.8659 -19.2732 |
DataGen.Address.SecondaryAddress | Returns a random secondary address. | =DataGen.Address.SecondaryAddress() Returns: Suite 895 Apt. 548 Apt. 511 |
DataGen.Address.State | Returns a random state. | =DataGen.Address.State() Returns: Orissa Pondicherry Jammu and Kashmir When Locale is set to en_IND. |
DataGen.Address.StateAbbr | Returns a random state abbreviation. | =DataGen.Address.StateAbbr() Returns: UT OK VA When Locale is set to en_US. |
DataGen.Address.StreetAddress | Returns a random street address. | =DataGen.Address.StreetAddress()
Returns: Ängsvägen 15 Norra Åkergatan 862 Övre Järnvägsgärdet 720 When Locale is set to SV. |
DataGen.Address.StreetName | Returns a random street name. | =DataGen.Address.StreetName() Returns: Allée de Tilsitt Rue de Seine Passage Saint-Séverin When Locale is set to fr. |
DataGen.Address.StreetSuffix | Returns a random street suffix. | =DataGen.Address.StreetSuffix() Returns: park straat plantsoen When Locale is set to nl. |
DataGen.Address.ZipCode | Returns a random zip code. | =DataGen.Address.ZipCode() Returns: TN01 2XU YP23 1FE UO8 1BQ When Locale is set to en_GB |
Product and company
Functions that generate company and product information.
Function Name | Description | Example |
---|---|---|
DataGen.Commerce.Category | Returns a random product category. | =DataGen.Commerce.Category Returns: Electronics Automotive Home |
DataGen.Commerce.Color | Returns a random color. | =DataGen.Commerce.Color Returns: gold yellow ivory |
DataGen.Commerce.Price | Returns a random product price. The function is formatted =DatGen.Commerce.Price(minimum value, maximum value, number of decimal places, currency symbol). Note: the cell must be formatted to the relevant currency for the symbols to be generated. | =DataGen.Commerce.Price(1,4,2,"$") Returns: $2.46 $1.78 $2.54 When the cell is formatted to currency, with the symbol “$” set. |
DataGen.Commerce.Product | Returns a random product. | =DataGen.Commerce.Product() Returns: Salad Chicken Computer |
DataGen.Commerce.ProductAdjective | Returns a random product adjective. | =DataGen.Commerce.ProductAdjective Returns: Sleek Refined Fantastic |
DataGen.Commerce.ProductMaterial | Returns a random product material. | =DataGen.Commerce.ProductMaterial Returns: Metal Rubber Cotton |
DataGen.Commerce.ProductName | Returns a random, three word product name, combining adjective, material, product type. | =DataGen.Commerce.ProductName() Returns: Generic Frozen Towels Rustic Wooden Chair Incredible Steel Mouse |
DataGen.Company.Bs | Returns a random piece of company jargon or management speak. | =DataGen.Company.Bs() Returns: generate next-generation relationships scale e-business relationships maximize ubiquitous markets |
DataGen.Company.CatchPhrase | Returns a random company catch phrase. | =DataGen.Company.CatchPhrase() Returns: Implemented content-based moderator Assimilated incremental Graphical User Interface Down-sized object-oriented artificial intelligence |
DataGen.Company.CompanyName | Returns a random company name. | =DataGen.Company.CompanyName() Returns: Garnier - Perrot Rosenbaum Group Reilly – Hermann When Locale is set to en_GB |
DataGen.Company.CompanySuffix | Returns a random company suffix. | =DataGen.Company.CompanySuffix() Returns: Inc Ltd and Sons |
Database
Functions that generate metadata describing a database.
Function Name | Description | Example |
---|---|---|
DataGen.Database.Collation | Returns a random database collation. | = DataGen.Database.Collation() Returns: cp1250_general_ci ascii_general_ci utf8_bin |
DataGen.Database.Column | Returns a random database column name. | =DataGen.Database.Column() Returns: createdAt token status |
DataGen.Database.Engine | Returns a random database storage engine. | =DataGen.Database.Engine() Returns: CSV MEMORY BLACKHOLE |
DataGen.Database.Type | Returns a random database column type. | =DataGen.Database.Type() Returns: bigint real serial |
Dates
Functions that generate dates.
Function Name | Description | Example |
---|---|---|
DataGen.Random.RandomDate | Returns a random date within a specified range. The function is formatted =DataGen.SequenceInt(“day, month, year”, “day, month, year”). Note: the cell must be formatted to date, with the correct format. | =DataGen.Random.RandomDate("1/1/1900", "7/19/2018") Returns: 8/21/1900 2/4/1909 5/13/1989 When the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US). |
DataGen.Date.Future | Returns a random date in the future, with the number of future years specified in the format =DataGen.Date.Future(number of years to go forward) . Note: the cell must be formatted to date, with the correct format. | =DataGen.Date.Future(4) Returns: 10/27/2021 4/20/2022 8/15/2019 When the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US). |
DataGen.Date.Month | Returns a random month. | =DataGen.Date.Month() Returns: January February December |
DataGen.Date.MonthAbbr | Returns a random month abbreviation. | =DataGen.Date.MonthAbbr Returns: Jan Mar Nov |
DataGen.Date.Past | Returns a random date in the past, with the number of past years specified in the format =DataGen.Date.Past(number of years to go back). Note: the cell must be formatted to date, with the correct format. | =DataGen.Date.Past(80) Returns: 2/14/1950 4/25/1944 8/7/1979 When the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US). |
DataGen.Date.Recent | Returns a random date within a number of days of the current date, specified in the format =DataGen.Date.Recent(number of days). The number of days is set to 30 by default. Note: the cell must be formatted to date, with the correct format. | =DataGen.Date.Recent(5) Returns: 9/6/2018 9/6/2018 9/5/2018 When the function is executed on 10/09/2018 and the cell formatting is set to number/date/*3/14/2012 and the locale is set to English (US). |
DataGen.Date.Weekday | Returns a random weekday | =DataGen.Date.Weekday() Returns: Friday Wednesday Sunday |
DataGen.Date.WeekdayAbbr | Returns a random weekday abbreviation | = DataGen.Date.WeekdayAbbr() Returns: Tues Sun Mon |
Finance
Functions that generate account, currency, and transaction information.
Function Name | Description | Example |
---|---|---|
DataGen.Finance.Account | Returns a random account number. | =DataGen.Finance.Account() Returns: 84296305 23065655 16099530 |
DataGen.Finance.AccountOfSpecifiedLength | Returns a random account number of a length specified in the format =DataGen.Finance.AccountOfSpecifiedLength(number of digits). The number of digits is set to 8 by default. | =DataGen.Finance.AccountOfSpecifiedLength(12) Returns 12 Digit Account Numbers: 005968327716 548027231195 818407984863 |
DataGen.Finance.AccountName | Returns a random account name like Savings, Checkings, Home Loan etc. | =DataGen.Finance.AccountName() Returns: Savings Account Personal Loan account Savings Account |
DataGen.Finance.Amount | Returns a random amount within a specified range. | =DataGen.Finance.Amount() Returns: Credit Card Account Savings Account Personal Loan Account |
DataGen.Finance.AmountWithDetails | Returns a random amount within a range specified in the fromat =DataGen.Finance>AmountWithDetails(minimum amount, maximum amount, number of decimal places). | =DataGen.Finance.AmountWithDetails(1, 1000,2) Returns a random amount between 1 and 1000, and two decimal places: 265.53 259.83 954.03 |
DataGen.Finance.Bic | Returns a random bank identifier code (Bic). | =DataGen.Finance.Bic() Returns: TOXECRZ1399 UOTUGNB1 TWJAGDQ1 |
DataGen.Finance.BitcoinAddress | Returns a random bitcoin address. | =DataGen.Finance.BitcoinAddress() Returns: 3M0Z1F9R7Z79H04F9R5Y4KQ10634 3BS6SB09WYY9BK9BG6Y40CHCMJH4B7 1RS9Q8JY968NPLXNJY11Y21D57MXDE88WJ |
DataGen.Finance.CreditCardNumber | Returns a random valid credit card number. | =DataGen.Finance.CreditCardNumber() Returns: 6767-5069-6253-4893-027 6759-5377-4241-9170 3529-2124-4921-0837 |
DataGen.Finance.Currency.Code | Returns a random currency code. | =DataGen.Finance.Currency.Code() Returns: USD XTS MOP |
DataGen.Finance.Currency.Description | Returns a random currency description. | =DataGen.Finance.Currency.Description() Returns: IRR DKK RWF |
DataGen.Finance.Currency.Symbol | Returns a random currency symbol. | =DataGen.Finance.Currency.Symbol() Returns: £ TT$ ? |
DataGen.Finance.TransactionType | Returns a random transaction type: Deposit, Withdrawl, Payment or Invoice. | =DataGen.Finance.TransactionType() Returns: payment withdrawal payment |
Name
Functions that generate names, prefixes, and job descriptors.
Function Name | Description | Example |
---|---|---|
DataGen.Name.FirstName | Returns a first name. | =DataGen.Name.FirstName Returns: ? ?? ?? When Locale is set to ja |
DataGen.Name.FullName | Returns a full name. | =DataGen.Name.FullName() Returns: Ramon Karlsson Amy Svensson Neil Nilsson When Locale is set to sv |
DataGen.Name.JobArea | Returns a job specialism. | =DataGen.Name.JobArea() Returns: Integration Solutions Group |
DataGen.Name.JobDescriptor | Returns a job descriptor. | =DataGen.Name.JobDescriptor() Returns: Senior Customer Corporate |
DataGen.Name.JobTitle | Returns a job title. | =DataGen.Name.JobTitle() Returns: Human Accounts Executive Customer Directives Manager Product Paradigm Assistant |
DataGen.Name.JobType | Returns a job type. | =DataGen.Name.JobType() Returns: Dynamic Program Associate Customer Paradigm Manager Chief Applications Analyst |
DataGen.Name.LastName | Returns a last name. | =DataGen.Name.LastName() Returns: Ferrara Costantin Bianc When Locale is set to it |
DataGen.Name.Prefix | Returns a name prefix. | =DataGen.Name.Prefix() Returns: ?????? ????? ?????? When Locale is set to el |
DataGen.Name.Suffix | Returns a name suffix. | =DataGen.Name.Suffix() Returns: I Sr. V |
Phone
Functions that generate phone numbers in specific formats.
Function Name | Description | Example |
---|---|---|
DataGen.Phone.PhoneNumber | Returns a random phone number, specified by the locale. | =DataGen.Phone.PhoneNumber() Returns: +910245048269 +912292980049 +91289-806-9090 When Locale is set to en_IND |
DataGen.Phone.PhoneNumberWithFormat | Returns a random phone number, specified by the locale. Formats are specified within bracket and double quotation marks. Hash signs (#) will be replaced with a random number, and all other characters such as spaces, dashes, and bracket, will be replicated literally. | =DataGen.Phone.PhoneNumberWithFormat("(0)#### ######") Returns: (0)9238 323314 (0)8239 933496 (0)6060 966141 When Locale is set to es |
Internet
Functions that generate information relating to email, IP, URL, and online account details.
Function Name | Description | Example |
---|---|---|
DataGen.Internet.Avatar | Returns an online avatar. | =DataGen.Internet.Avatar() Returns: https://s3.amazonaws.com/uifaces/faces/twitter/nbirckel/128.jpg https://s3.amazonaws.com/uifaces/faces/twitter/a1chapone/128.jpg https://s3.amazonaws.com/uifaces/faces/twitter/traneblow/128.jpg |
DataGen.Internet.DomainName | Returns an internet domain name. | =DataGen.Internet.DomainName() Returns: samuel.es clemente.info patricio.info |
DataGen.Internet.DomainSuffix | Returns a domain name suffix e.g. .com, .net, .org | =DataGen.Internet.DomainSuffix() Returns: es org info |
DataGen.Internet.DomainWord | Returns a random word used in domain names. | =DataGen.Internet.DomainWord() Returns: rosario ramona eva |
DataGen.Internet.Email | Returns an email address. | =DataGen.Internet.Email() Returns: Carolina42@gmail.com Catalina_Galarza61@hotmail.com Ramona23@gmail.com |
DataGen.Internet.EmailWithDetails | Returns variations of an email using a first name, last name, and provider, specified in the format =DataGen.Internet.EmailWithDetails(“firstname, lastname, provider”). | =DataGen.Internet.EmailWithDetails("firstname", "lastname", "provider.com") Returns: firstname_lastname@provider.com firstname.lastname77@provider.com firstname_lastname59@provider.com |
DataGen.Internet.Ip | Returns an IP address. | =DataGen.Internet.Ip() Returns: 222.88.182.155 55.114.248.110 134.228.149.234 |
DataGen.Internet.Ipv6 | Returns an IP V6 address. | =DataGen.Internet.Ipv6() Returns: ba3a:2ba4:b6b3:5360:f9a6:3747:95e2:504 803e:69ea:b832:c096:76d5:4d32:10:9685 146a:29ab:f04c:afa:2cab:8163:85d:2eb |
DataGen.Internet.Mac | Returns a Mac address. | =DataGen.Internet.Mac() Returns: 3d:59:9f:a7:ab:07 87:c1:38:8e:8d:9d a9:5c:91:4b:ed:ec |
DataGen.Internet.Password | Returns a password. | =DataGen.Internet.Password() Returns: fBUMRer2Wa 7n3Ku5RcHW 9enZAxmV_r |
DataGen.Internet.PasswordWithDetails | Returns a password of a length specified in the format =DataGen.Internet.PassWithDetails(number of characters). | =DataGen.Internet.PasswordWithDetails(6) Returns: lvTV5g vJ2RvY vWyLJX |
DataGen.Internet.Protocol | Returns a protocol http or https. | =DataGen.Internet.Protocol() Returns: http https https |
DataGen.Internet.Url | Returns a URL. | =DataGen.Internet.Url() Returns: https://lourdes.com https://federico.com http://jacobo.es |
DataGen.Internet.UserAgent | Returns a UserAgent. Data generated by this function reflects the prevalence of Mozilla over Opera. | =DataGen.Internet.UserAgent() Returns: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_9_9 rv:6.0; BO) AppleWebKit/538.1.2 (KHTML, like Gecko) Version/4.1.6 Safari/538.1.2 Opera/10.22 (Windows NT 5.2; U; UR Presto/2.9.166 Version/12.00) Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 5.2; Trident/6.0; .NET CLR 2.6.29901.2) |
DataGen.Internet.UserName | Returns a username. | =DataGen.Internet.UserName() Returns: JoseEmilio_Valle Daniela_Godoy94 Rosa.Cardona92 |
DataGen.Internet.WithDetails | Returns a username using variations of a first and last name, specified in the format =DataGen.Internet.WithDetails(“firstname”, “lastname”). | =DataGen.Internet.WithDetails(“first”, “last”) Returns: first.last22 first.last first91 |
“Hacker”
Functions that generate basic linguistics units loosely associated with hackers.
Function Name | Description | Example |
---|---|---|
DataGen.Hacker.Abbreviation | Returns an abbreviation for a random word. | =DataGen.Hacker.Abbreviation() Returns: IB SAS CSS |
DataGen.Hacker.Adjective | Returns a random word which, in this case, is an adjective. | =DataGen.Hacker.Adjective() Returns: optical open-source optical |
DataGen.Hacker.IngVerb | Returns a random '-ing' verb, a present participle. | =DataGen.Hacker.IngVerb() Returns: parsing quantifying indexing |
DataGen.Hacker.Noun | Returns a random word which, in this case, is a noun. | =DataGen.Hacker.Noun() Returns: pixel driver system |
DataGen.Hacker.Phrase | Returns a phrase. | =DataGen.Hacker.Phrase() Returns: If we index the panel, we can get to the RAM panel through the redundant RAM panel! |
DataGen.Hacker.Verb | Returns a random word which, in this case, is a verb. | =DataGen.Hacker.Verb() Returns: navigate reboot input |
Text
Functions that generate placeholder text.
Function Name | Description | Example |
---|---|---|
DataGen.Lorem.Lines | Returns lines of lorem ipsum filler text. | =DataGen.Lorem.Lines() Returns: Ut explicabo doloremque incidunt aperiam eum. Sed iusto repellendus cupiditate accusantium illum explicabo. Iure commodi veritatis beatae quis placeat id aut. Voluptatibus consequatur officiis sint quos nam cupiditate nemo reprehenderit. Eaque qui id est hic cum. Iusto veritatis et hic eum. Cum est voluptatibus at nam consequatur. Quod vitae ad dolore accusantium a nobis quo. Quaerat numquam harum eos dolorum nobis doloribus possimus quis. Ducimus ipsum rerum consequuntur doloremque quia qui et. |
DataGen.Lorem.Paragraph | Returns one paragraph of lorem ipsum filler text. | =DataGen.Lorem.Paragraph() Returns: Libero rerum accusantium tempora minus tenetur quia ea. Doloribus asperiores officia nam et velit voluptatem ut. Doloribus minus modi similique provident tempore quis sunt eos. Numquam pariatur error odio. Deserunt sunt est. Necessitatibus qui accusamus in ut eos nihil vero. Ratione quo quo quia sed magnam doloremque. Aspernatur aut ex earum nesciunt illum. Eveniet molestiae omnis facilis. Non quo impedit suscipit delectus voluptatem et. Doloremque qui delectus molestiae et doloribus et quas facilis. Amet repudiandae harum. |
DataGen.Lorem.Paragraphs | Returns a number of paragraphs of lorem ipsum filler text., specified in the format =DataGen.Lorem.Paragraphs(number of paragraphs) | =DataGen.Lorem.Paragraphs(2) Returns: "Aliquam eligendi minus voluptates necessitatibus aliquam. Quo voluptatem non recusandae itaque officiis alias accusamus. Doloribus dolorem harum quasi quo iure excepturi. Eum perspiciatis rerum. "Et debitis sapiente. Id autem iste aut tempore distinctio ut error illum. Recusandae consectetur itaque qui laborum nihil aut iste voluptates quis. Sint a minima deleniti odit consequatur velit. |
DataGen.Lorem.Sentence | Returns a sentence of lorem ipsum filler text. | =DataGen.Lorem.Sentence() Returns: Odio dolorem unde alias officiis illo doloribus quia aut cupiditate. |
DataGen.Lorem.Sentences | Returns a number of sentences of lorem ipsum filler text., specified in the format =DataGen.Lorem.Paragraphs(number of sentences) | =DataGen.Lorem.Sentences(2) Returns: Autem enim debitis non quisquam deleniti. Labore quibusdam et. Quis aut facere. Omnis exercitationem modi architecto excepturi assumenda reprehenderit sunt et nihil. Illum excepturi vel sed vero illum quos sed culpa. Nostrum sit minima reprehenderit. Facere voluptas ab. Rerum molestiae itaque quaerat odit quod modi. Dolorem dolorum voluptatibus eius magnam qui. |
DataGen.Lorem.Slug | Returns a lorem ipsum slug of length specified in the format =Datagen.Lorem.Slug(numer of words) | =DatGen.Lorem.Slug(4) Returns: iusto-et-autem-tempore id-et-aut-enim nostrum-repudiandae-est-officia |
DataGen.Lorem.Text | Returns text using one of the other Lorem functions. | =DataGen.Lorem.Text() Returns: Sit voluptatem maiores libero error corrupti nesciunt. Numquam sit maiores id. Animi qui molestiae similique maiores voluptatem. Dolore voluptatem vero sed ab iusto porro hic sit eos. Numquam adipisci tempora natus quam quas quia ipsa. Sit esse vel cum veniam similique sit. Ratione reiciendis ducimus vel in quis voluptatem et quaerat. Error adipisci nostrum laborum quae aliquid. |
DataGen.Lorem.Word | Returns a ipsum word | =DataGen.Lorem.Word() Returns: nemo dolorem accusamus |
DataGen.Lorem.Words | Returns a number of ipsum lorem words | =DataGen.Lorem.Words() Returns: dolorum consequuntur assumenda non consequatur beatae aliquid est perspiciatis |
DataGen.Lorem.Review | Returns a user review in English. | =DataGen.Lorem.Review() Returns: My co-worker Atha has one of these. He says it looks narrow. My chicken loves to play with it. This product works outstandingly well. It grudgingly improves my baseball by a lot. |
String Extensions
Functions that process a string.
Function Name | Description | Example |
---|---|---|
DataGen.General.Random.Parse | Returns a string value after resolving a set of functions specified in the format =DataGen.Random.Parse(“{{function1}} {{function2}} {{functionN}}”). | =DataGen.Random.Parse("{{name.prefix}} {{name.lastname}} {{name.suffix}}") Returns: Dr. Herman MD Mrs. Koch DVM Mrs. Bogisich III |
DataGen.General.Random.Spin | Returns a random string value after ‘spinning’ text. Spinning generates variations of variables specified in the format =DataGen.Random.Spin(“{{variable 1|variable2|variable}}”). Spin functions can be strung together. Values outside of squiggly brackets will be reproduced literally. | =DataGen.Random.Spin("{{Red|Yellow} is {my|your} {favourite|least favourite} colour }") Returns Yellow is my least favourite colour Red is my favourite colour Red is your least favourite colour |
DataGen.Random.RandomStringFixedLength | Returns a random string of fixed length with or without numbers and special characters. The function is formatted =DataGen.Random.RandomStringFixedLength(length, includeNumbers, includeSpecialChars) | =DataGen.Random.RandomStringFixedLength(7,TRUE,TRUE)
Returns: vXf2P=G D%r=nNV Gjs3$d1 |
-
-
-
- IEnumerable to Data Reader
- Data Table to List
- Nested String List to Data Table
- List to Data Table
- IEnumerable to List
- List to IEnumerable
- Remove from List
- Exists in List
- Value Exists in Dictionary
- Key Exists in Dictionary
- Remove from Dictionary
- Get from Dictionary
- Clear Dictionary
- Add to Dictionary
- Clear List
- Add to List
- Show all articles ( 1 ) Collapse Articles
-
-
-
-
- Explanation of Remaining Sheets in the Control Spreadsheet (for reference only)
- The ForeignKeys Sheet - Specifying which Foreign Keys to read from the Source Database
- The Tables Sheet: Defining Metadata that will be read from the Source Database
- The ProcessModel sheet – Toggling Subset Rules
- Refining the Control Spreadsheet
- Overview of the Advanced Control Spreadsheet
- Introduction
-
- Drop both Primary and Foreign Keys (The composite DROPKEYS Action)
- Validate Both Primary and Foreign Keys (The composite ValidateKeys Action)
- Add Both Primary and Foreign Keys (The Composite ADDKEYS action)
- Drop Tables
- Truncate Data
- Delete Orphans
- Drop Primary Keys
- Drop Foreign Keys
- Validate that Foreign Keys are Unique
- Validate that Primary Keys are Unique
- Add Foreign Keys
- Add Primary Keys
- Overview of Post-Subset Actions
-
-
- Use Event Hooks to call VIP Flows
- Different Methods for Connecting to Source Databases
- PreProcess Variables and Parameters
- Using SQL Functions to query Databases and Using the Queries in Data Generation Functions
- Summary of the Process to Configure the Test Data Configuration sheet
- How the PreProcessVariables Table is used in the Configuration sheet
- Sample Commerce Configuration Sheet Examples
- Adding Event Hooks in Configuration sheet for custom functionality
- How to Configure the Synthetic Test Data Configuration Control Sheet
-
-
-
-
-
- The UI Recorder
- Test Modeller – Maintenance
- Test Modeller Core (Linux) Optional – Postgres LDAP
- Test Modeller Core (Linux) Optional – SSL Certificate Installation
- Test Modeller Core (Linux) Optional – Active Directory
- Test Modeller Core (Linux) Installation
- Test Modeller: Software Pre-requisites
- Test Modeller : Installation components
- Test Modeller : System requirements (Windows, Linux)
-
-
-
-
-
-
- Common Problems
- Extend Test Modeller (Advanced)
- Edit Code Templates (Advanced)
- Import existing framework / custom page objects (Advanced)
- Execute Tests (Java)
- Generate Automation Code
- Build a Model (Java)
- Scan an Existing Web App
- Configuration (Java)
- Prerequisites (Selenium Java)
- Welcome Selenium (Java)
-
-
-
-
- Generate Optimised Test Cases and Data into Excel
- Implement Naming Conventions
- Page Object Generation
- Intelligent Page Objects
- Customising Page Objects
- Import Custom Code Snippets
- Rule-Based Test Generation
- Trigger Automation Execution from within Test Modeller
- Automation Configuration
- Test Data Automation for Gherkin Specifications
-
-