Articles.
In 2016, DEV3LOPCOM, LLC began sharing informative articles and technical tutorials about software, methodologies, research and programming languages.
Recent Articles
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...
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...
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! Like a guitar pedal, there's an input and output. Sometimes it's just an output....
ET1’s 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...