Applying data transformations to more than one field at a time
Being able to apply transformations to several fields at a time is a huge advantage Alteryx provides to us as analysts. From updating all months’ data to correcting or replacing strings in one go is a real improvement in the amount of time needed to adjust our data.
In this recipe, we’ll go through the process of updating several fields all at once.
Getting ready
For this recipe, we created a test set for you to follow. You can download it here:
https://github.com/PacktPublishing/Alteryx-Designer-Cookbook/tree/main/ch3/Recipe3.
If you decide to test it with your own data, make sure your dataset contains several fields that you need to apply a single function to (such as capitalization, or applying a formula to them).
How to do it…
We’ll transform our data as follows:
- Create a new workflow and drop the Input Data tool.
- Point the Input Data tool to
DATA\ARTICLES...
