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 […]| Dev3lop
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 radial menu we are calling […]| 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 […]| 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 […]| 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 […]| 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. […]| Dev3lop
