Articles.

In 2016, DEV3LOPCOM, LLC began sharing informative articles and technical tutorials about software, methodologies, research and programming languages.

Recent Articles

Using Your Hands in ET1

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 Unique Filter Node

ET1 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

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 Duplicate Columns Node

ET1 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...

ET1’s DAG Streaming System

ET1’s DAG Streaming System

Familiar with graphs? How about DAGs? This is not a paradigm shift, but think of DAG as a cool way for tiny team in Austin/Dallas Texas to build an Extract Transform and Load software! Think of "DAG" like rules, which enable data processing unlike software like...

ET1 Aggregation Node Overview

ET1 Aggregation Node Overview

Aggregation, what a classic. Aggregating your data is a landmark trait for any data steward, data wrangler, or data analyst. In ET1, you can easily aggregate your data. The Power of Grouping (Group By in ET1) with the Aggregate Node Aggregations turn a sea of numbers...

ET1 Data Combination Tools

ET1 Data Combination Tools

Are you combining the data? We have you covered. ET1 has all the right tools. The Three Musketeers of Data Combination 1. 🤝 Join (The Matchmaker) What it does: Combines tables based on matching values Perfect for: Merging customer data with their orders Adding product...

Filtering Nodes in ET1

Filtering Nodes in ET1

The filtering nodes help you reduce the number of rows, drill into the exact information needed, and create a data set that will add value VS confuse your audience. When filtering, remember you're reducing the amount of data coming through the node, or you can swap to...

ET1’s Data Input Node Overview

ET1’s Data Input Node Overview

CSV, JSON, and Public CSV endpoints or manual tables. These help you kick start your data pipeline. Once your data comes into the data input, it begins to flow downstream using a custom DAG streaming engine. Input Node Overview The Input nodes are essential for moving...

ET1 Basic Training

ET1 Basic Training

ET1 helps you extract, transform, and load data in a single user-friendly canvas. Data automation in a single canvas. Each node is simple and easy to use in VR/AR headsets. Welcome to basic training, where we show you the basics so that you're dangerous. Don't worry...

About ET1, A Tool to Help Uncomplicate Data

About ET1, A Tool to Help Uncomplicate Data

It is undeniable that data can be overwhelming, and those who work with it daily are adept at navigating this complexity. ET1 is designed to assist individuals in managing this chaos, eliminating the constraints associated with outdated software that is over 20 years...

Evolving the Perceptions of Probability

Evolving the Perceptions of Probability

What does the CIA’s “estimation probability” have to do with data visualization and a Reddit poll? Think of it like this: the CIA, and many government agencies, has teams who dig through research, write up reports, and pass them along to others who make the big calls....