How to update attribute values in Tableau Prep Builder?

I have a Hadoop table with an attribute (column) named "state". Some values say "Work in Progress", and some say "Work In Progress", so they show up as two distinct groups when grouping on "state". How can I UPDATE all "Work In Progress" to "Work in Progress" the the flow?

I tried a Clean step in the flow but I do not see any kind of update function, as I was expecting.

Here are the updated steps to standardize the values in the "state" column in Tableau Prep Builder:

1. Open your flow in Tableau Prep Builder and load the table containing the "state" column.

2. Add a Clean Step (or use an existing one if you've already added it) to work with the data.

3. Select the "state" column in the Clean step.

4. Apply a Cleaning Transformation:

   • In the right panel, you will see the list of values in the "state" column.

5. To standardize values like "Work in Progress" and "Work in Progress", follow these steps:

   1. Right-click on the "state" column in the Clean step.

   2. Select "Replace Values" from the context menu.

6. In the Replace Values dialog, do the following:

   • In the "Find" field, type the variation of "Work in Progress" you want to change.

   • In the "Replace with" field, type the correct version ("Work in Progress").

7. Click OK to apply the change.

8. Check the Results: Ensure that all instances of "Work in Progress" have been updated to the correct format.

9. Continue your flow to apply the changes to the rest of your data.