Unioning data sources with different structures
It is a very common situation to find that we need to stack up a series of data sources, either because we have the data scattered in several files, we receive different files from different vendors, or we need to blend actual data with historic ones. No matter which use case is yours, we’ll find a very simple way to do it within Alteryx.
Getting ready
We have a whole test set ready for you to try this recipe here: https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch7/Recipe2.
If you want to go with your own data, just use some that has at least a couple of fields that are the same type of information (it may be a field that represents sales amounts but with different names and/or orders within your files/tables).
In both cases, we’ll make these different structure files make sense with this recipe.
In the test dataset, we have a list of customers from different countries/regions. The...
