Skip to main content

Data Grid Editable

The Data Grid Editable workflow is the main app at:

  • https://anywaydata.com/app.html

It is designed for interactive editing where generated data and manual edits happen in the same grid.

By 'opening' the Test Data section in the GUI it is possible to Generate a Data Grid filled with Random Data.

What this page is best for​

  • importing and editing existing table data
  • generating random data directly into the visible grid
  • refining data by hand before exporting
  • switching between many data formats quickly

Test Data section in app.html​

Open the Test Data section to define generation rules.

The definition grid acts as a schema/template:

  • each row maps to one target output column
  • choose a type (Literal, RegEx, Enum, Faker)
  • configure row count with How Many?
  • press Generate (or Generate Pairwise when applicable)

Generated rows are inserted into the main editable data grid.

Generate Modes in the Grid​

When generating in app.html, you can choose whether generation replaces data or amends existing rows:

  • New Table clears/rebuilds the table from the schema and generates a fresh data set
  • Amend Table updates the current table while preserving existing rows where possible
  • Amend Selected applies generation only to selected rows in the main grid

These modes are useful when you want to iteratively enrich existing data instead of always starting from a blank table.

Pairwise generation​

When you configure two or more Enum fields, pairwise generation is available to create efficient combinatorial coverage sets.

See All Pairs Combinatorial Testing.

Schema text area support​

When you add rows using the data grid, you will see the information is also copied into the text area in the right. This allows you to copy and paste schema definitions for re-use.

The Schema format in the Text Area uses the format

column name
type value

e.g.

column 1
1234

When no type is present it is assumed to be a Regex e.g. 1234 is a Regex that represents the string "1234"

Test Data Grid​

The Test Data Grid contains the 'schema' or 'template' to use to generate data for the grid.

Each row represents a Column in the final data grid.

Add a new column by pressing the + Add Column button.

You can rename the column by double clicking on the Column Name field.

The Type is the type of data that will be generated in the column. This can be a Literal (static text), a RegEx (Regular Expression), an Enum (comma-separated values), or one of the predefined random data types from Faker.

When you have 2 or more Enum type columns, the Generate Pairwise button will appear, allowing you to generate optimal combinatorial test data with complete pairwise coverage.

Types​

The Types of data available can be chosen from the drop down value.

The drop down is an option select so you can type in a filter e.g email and you will see any matching options for email.

Number of Rows to Generate​

Configure how many rows of data to generate by typing the numeric value in the How Many? text field.

e.g. to generate 1000 rows of data enter 1000 in the How Many? text input field.

Generating Data​

Press the [Generate] button to generate the data.

The schema in the Column Definition Data Grid will be used to generate the data.

All data generation happens in the browser so the amount of data you can generate is limited only by the performance and memory of your computer.