by Augusto Terra | Jan 31, 2025 | Augusto Terra
When you first start working with Alteryx, some of the most commonly used tools are Append, Join, and Union. These tools are located in the Join tab, which is marked with a purple icon. As their names suggest, they are used to combine and merge data from different...
by Don Kang | Dec 13, 2024 | Don Kang, The Data School
Comparison of Union, Join, and Append When we analyze data from different sources, we often need to combine two or more tables into one to process the data in the next step. This process is commonly referred to as “joining tables,” and there are various...
by The Data School | Dec 20, 2022 | The Data School
If you have been using Alteryx for a while and have used the Join tool, I am quite confident that you have come across this scenario a few times. When you join two data sets using specific fields that have identical field names, you will have duplicate values from the...
by Jonathan Waerner | May 3, 2019 | Jonathan Waerner
This week I decided my spare time should focus on revising Spatial Tools in Alteryx and using API’s. Up until this point, I had only successfully retrieved data from one API (cheers Zomato). Along the way, I have been unsuccessful with a few others, so I was...
by Pris Lam | Feb 18, 2019 | Pris Lam
Data comes in all shapes and sizes. But what happens if the data you’re wrangling is in the millions of records? Having worked with data with several million rows of data in the past few client projects, there’s been times where running a single Alteryx...