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 row count at a row level per row.
Assuming this will help them understand how bananas this csv file feels.
ET1 is able to append fields using the Joiner node!
Before the join node, we simply utilize an aggregate column to count rows. You could also swap this to aggregate any measure in the data pipeline.
Joiner automatically infers the join using similar column headers and matches the default header column ‘const’ applied in the constant node.
Creating the append field solution in ET1
Using the join to merge the data across rows, and then the constant to create a joinable column. Here’s the exact settings.
Append field is all about knowing how to join to a table.
Joiner has the ability to inner join, left join, and assume the left/right side of the join based on what you plug into the node first. Joins can be used as a filter, a labeler, a way to append fields, merge tables, and join at a row level with primary key to foreign key.
With ET1 we make this entire process of appending data at a row level easy to do, so that you’re able to complete the same solution as Alteryx’s Append Tool.
Questions? Please contact us.
Return to ET1 Overview to learn more.
