Dynamically renaming fields

Dealing with field names is crucial in our data journey. From structure homologation to missing field names and everything in between, we need to know these techniques, and that’s what we will tackle in this recipe.

At first, you may think of a Select tool to get this job done, but we will use a more dynamic process here.

Getting ready

We prepared a test set for you to follow along with this recipe. You can download it here: https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch9/Recipe1.

We’ll be using the Dynamic Rename tool to fix some of the most common situations we’ll find with headers, either due to lack of them, differences/errors in their naming, or to standardize structures between different data sources.

In our test set, we have several files we need to combine, starting with a list of customers by City (in CSV format without headers). Also, to help us get the correct header names, we grabbed...