Instadeq Workspace Tour

Calculate Fields

Set the value of a field as the result of a formula, drop fields into values to use them in the calculation.

If calculating a field for each item in a list, drop the list index into the formula to apply it to all items.

Set formula

Filter Events

Ignore unwanted events by defining a filter condition.

Filter Events

Do Complex Transformations

Advanced operations with parameters are a click away, edit the parameters by double-clicking them or just drop a field to make them dynamic.

Transform Fields with Parameters

Edit Changes

Review, edit, reorder and remove actions applied to data in the Changes tab.

Edit changes

Filter Items in a List

Ignore list items according to any condition.

Filter Items in a List

Aggregate Multiple Values per Event

Calculate and summarize multiple values per event by using iterator indexes in the summary aggregation.

Aggregate Multiple Values per Event

Convert Fields between Types

Convert fields between types, instadeq will recommend available transformations according to the field's value type.

Convert date to record
Table Data Type

Manipulate Tabular Data

Explore and manipulate tabular data from CSVs, Excel and Google Spreadsheets, extract and manipulate rows, columns or individual values by dragging and dropping.

Rename Fields

Rename fields to clarify its meaning by selecting a field and clicking the Rename action.

Rename field
Replace field

Replace Fields

Drop a field into another and select Replace to replace its value.

Insert as Field in a Record

Drop a field into record field and select Insert as Field

Insert as field
Remove field

Remove Fields

Remove unwanted fields by selecting a field and clicking the Remove action.

Zoom to Fields

Zoom to a specific field to focus on the data you care about by selecting the Zoom action.

Zoom to field
Insert first in list

Insert First in a List

Prepend a field into a list by dropping it into the list's field name and selecting Insert First

Insert After List Item

Add a field into a list at a given position by dropping it into the previous field index and selecting Insert After

Insert after current in list
Insert last in list

Insert Last in a List

Append a field into a list by dropping it into the list's field name and selecting Insert First

Insert New Fields in a Record

Add fields to Records by selecting the Add New Field action.

Insert new field in a record