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 KPI, you need to choose the column and […]| Dev3lop
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 of entire business! Using Group By in ET1 Open […]| Dev3lop
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 / arrow. This flows data downstream. Then you […] The post ET1’s Measure Filter Node appeared first on Dev3lop.| Dev3lop
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 this data through the CSV Input […] The post ET1’s Split Node appeared first on Dev3lop.| Dev3lop
If a web-cam is available ET1 will automatically sync and help you navigate the software. Using computer vision we map a skeleton over your hands and able to create a radial menu we are calling Navigator. The skeleton helps us build a menu on your hand, like an augmented environment to solve problems, and change […] The post Using Your Hands in ET1 appeared first on Dev3lop.| Dev3lop
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 column. Duplicate rows happen, The Unique Filter node manages […] The post ET1’s Unique Filter Node appeared first on Dev3lop.| Dev3lop
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 and asked to append the […] The post Append Fields with ET1’s Joiner appeared first on Dev3lop.| Dev3lop
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 settings for this tool because today Duplicate Columns Node solves problems without requiring a […] The post ET1’s Duplicate Columns Node appeared first on Dev3lop.| Dev3lop
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. Then you have your input only tools. […] The post ET1’s DAG Streaming System appeared first on Dev3lop.| Dev3lop
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) with the Aggregate Node Aggregations turn a sea of numbers into meaningful insights. Group by in ET1 is nested in the […] The post ET1’s Aggregation Node Overview appeared first on Dev3lop.| Dev3lop
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) 2. 🔗 Union (The Stacker) 3. 🧵 Concat ([bring], [it], [together],[with],”glue”) Concat merges everything, and it doesn’t care about data types. Real-World Examples Join: Union: Concat: Pro Tips No […] The post ET1 Data Combination Tools appeared first on Dev3lop.| Dev3lop
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 include. Include, exclude, and ultimately work on your […]| Dev3lop