Fixing your field names after a Cross Tab operation
In the previous recipe, we didn’t see this behavior, but we modified the use case slightly to learn how to fix it.
When we use the Cross Tab tool to use the values of a field as field names, Alteryx replaces special characters with underscores, as we can see in the following example:
Figure 4.17: Characters replaced by the Cross Tab tool
In this recipe, we’ll learn how to fix this behavior and restore the values to their original state.
Getting ready
We will use the data from the previous recipe. If you need to download it, you can find it here: https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch4/Recipe2.
However, if you decide to practice on your data, make sure that you take the Cross Tab field names from a field that contains whitespace and/or special characters within its values.
How to do it…
- On a new workflow, add an Input Data tool...
