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
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?
ET1s Constant Node
The Constant Node creates a constant value per row in your data pipeline. This node is extremely handy when transforming data in your ETL processes. The Constant Node is rather straight forward, two inputs and you're done. Using the Constant Node Add the Constant Node...
ET1’s Concat Node
Bring your columns together as one with the Concat Node in ET1. This node is similar to concat() in Excel and allows you to easily bring more than 1 column together in your data pipeline, and also it gives you the ability to add the delimiter. The opposite of the...
ET1’s Find/Replace Node
Automatically finding and replacing data is possible using the Find/Replace Node! Find and replace works inside of sentences, words, numbers, and anywhere in the data. Similar to "find all" and "replace all," in your common Word Document software, ET1 offers the same...
ET1 Manual Table Node
Create a table manually using the Manual Table Node. Manual Table node falls under the data input node category. Built to help you create small tables that you need to use in your data pipelines. When you need a thin layer of data, this is a great tool for manually...
ET1’s Github CSV Node
ET1's Github CSV Node is designed to help end users extract data from Github CSV URLs which are in public repositories. A public repository on Github is not a place to put your private or company information. However City/State for USA is a commonly used resource in...
ET1’s CSV Input Node
The CSV Input Node, what a classic, flat files living on your computer can be consumed and the data can be extracted here in ET1. CSV is a common file type for data gurus. Comma-Separated Values, a plain text file format for storing tabular data with values separated...
ET1’s JSON Input Node
When extracting data from a JSON file, try the JSON Input Node. JSON (JavaScript Object Notation) is a common data source. With ET1's JSON Input Node you can quickly open your JSON files and begin to transform the data, merge it with other data like offline CSV Node...
ET1’s Trim/Normalize Node
Trim/Normalize Node is built to help you quickly clean your data pipelines and like the Column Renamer, built to make data pipeline maintaining simple, not complicated, and more than anything, easy to repeat. AT TIMES WE NEED CAPITAL LETTERS! Perhaps...
ET1’s Column Renamer Node
Renaming columns in ET1 is straightforward and intuitive. You can also move the position of your columns by bumping the column left or right. Last, but not least, the ability to remove the column from the table. Column Renamer in ET1 is the place to manage your...