Uncomplicate Data
ET1, for humans who hate complex
No ET phone home.
Data Inputs
CSV, JSON, and Github CSVs. Extract the data.
Filters
Filter by measure, use regex, wild cards, across your data.
Merge
Inner join, left join, stack with union, and concat columns.
Aggregate
Minimum, maximum, mean, sum, and yes, group by.
Streaming
Flow data downstream. Never click run.
Consulting
Expert help.
Keep it Simple.
About ET1
ET1 is a visual data workbench that lets you explore, clean, and explain data in-memory. Built for non-technical humans, (but developer friendly) who want to wrangle data, without complexity.
Create
Hands-on ETL
Training Documentation
Use the training material to help you understand more about ET1 and how it helps solve data wrangling problems.
ET1 Basic Training
If you need help getting started, begin here.
ET1 Video Training
Learn the basics, the features, and more.
Future Insight
We see the future being focused on adoption, training, and creating Easy Tools for anyone. We are building an emerging technology while also maintaining a creative user experience that is inviting and friendly for all ages.
Inspiration
We are inspired by software, video games, and Sci-Fi movies like The Matrix, Minority Report and Ironman. ET1 is created to be “some-what” similar to other legendary software like Alteryx Desktop, and KNIME Analytics Platform.
Join beta.
Why do you want to access beta?
ET1’s Joiner Node
On your magic quest to join data? We call it the Joiner node. A simple joining solution that helps people join data at a row level. In ET1, Joiner is focused on "keeping it simple" and will aim to automatically infers your joins. ET1 assumes. Inferring a join means it...
Create a KPI with ET1
Need a KPI? Aggregating the entire column into 1 value? ET1 has this capability built into the aggregation node. By using the Aggregation Node in ET1, and skipping the Group By column in ET1, you can immediately jump into creating column level KPI values. To create a...
ET1’s Group By Overview
Eager to group data? The Group By feature can be found in the Aggregation Node. Add the aggregation node to the canvas and send data downstream to this node. We have many products, however duplicate quantities across many suppliers, and we need to check the quantity...
ET1’s Measure Filter Node
When you have numbers, you have a need for a Measure Filter Node. Numbers are here, lets talk about it. Filtering with a number or decimal is straight forward using ET1. Using Measure Filter Node in ET1 Get started using the Measure Filter node. Attach data pipeline /...
ET1’s Split Node
The Split node lets ET1 user split one or more column into multiple columns. This particular node is great for the times you have multiple rows of data with consistent delimiters. The data we are splitting Here is the CSV you need to follow the overview. We will pass...
Using Your Hands in ET1
If a web-cam is available ET1's code will try to automatically sync and if you can wave and point, this radial menu is a fun way to augment your ETL development. Using computer vision (explained in depth below) we map a skeleton over your hands and able to create a...
ET1’s Unique Filter Node
The Unique Filter Node or Unique Tool finds unique values per row in your data pipelines, or allows people to quickly review duplicates only. Plus, you can select what column(s) to find unique values within. This enables people to easily understand what is inside of a...
Append Fields with ET1’s Joiner
Seeking to append fields like the Alteryx Desktop software? The Joiner Node and Aggregate node is here to help. You will also need a constant to join on across both data streams. We will show you how in this example below where we are sent 6million records in a CSV...
ET1’s Duplicate Columns Node
Dealing with duplicate columns? This particular node is designed to remove similarly named column headers. If "State"="State" then we remove the last column and only keep the first column. "Remove duplicate columns based on similar header names" Currently there are no...