Greetings everyone,

Have you ever pondered whether there exists an option to update multiple fields simultaneously in Alteryx? Well, the good news is that Alteryx provides a multi-field formula tool that can prove to be useful in certain scenarios.

Where Can we find this tool?

To access this tool, navigate to the “preparation” tab in Alteryx and then choose the “Multi-field formula” option.

To give you a better understanding of how this tool works, I have prepared a small dataset for this demonstration. Take a look at the examples below that use the multi-field formula tool in Alteryx.

Original dataset:

In this particular dataset, there are four fields that require some modifications. Specifically, I would like to convert the values in the “Full name” field to title case format, adjust the date of birth (DOB) formatting, and determine the current age of myself and my siblings. To accomplish these tasks, I will utilise the multi-field formula tool in Alteryx.

How to configurate the tool?

Starting from the left top side:
  • Select => When you choose the multi-field formula tool in Alteryx, you will be prompted to select the type of data field that you would like to modify. This feature is especially useful if you have a large dataset that contains various types of data fields, such as numeric, date, and text fields. However, for this example, I have chosen to leave all field types selected since I am working with a small dataset. Next, I selected the field that I want to modify, which is the “Full name” field. It is worth noting that you can select more than one field if needed.
  • “Copy Output field and Add => By selecting the “Copy Output field and Add” option, a new column containing the modified data will be added to the very left of the dataset. The name of this new field will have “New_” as a prefix or suffix. Please see below for an illustration of how this option would look if selected.

 

  • Change output type => Another useful feature of the multi-field formula tool in Alteryx is the ability to change the output type of your modified data. This feature enables you to convert your data to different types, including string, integer, Boolean, and more.

Within the multi-field formula tool, you can find a “Functions” tab that contains various functions to assist you in constructing the correct expression for your data modifications. In this particular case, I am using the “TitleCase” function to modify the initial letter of each word in the “Full name” field.

We can use the same tool to fix the DOB to correct date time formatting.

Finally, to find the current age:

 

If you would like more information on date formatting and other related topics, you can refer to this link: https://help.alteryx.com/20223/designer/datetime-functions.

Thank you for reading, and I hope that this mini tutorial will prove to be useful in your future projects.

The Data School
Author: The Data School