Data sources with different upper/lowercase letters

[Suedseeperle]

Dear Alteryx community, I joined data from two different excels, in one excel High and Low is in capital letters. How can I make it the same so that it will be counted as one? See the attached picture for details. Thx, Patricia

[Suedseeperle · Accepted solution]

Titlecase([_CurrentField_]) works

[tristank · Accepted solution]

Hi Patricia,

The easiest way is to standardize the fields using a formula tool and a case function (like title case).

Here is the original structure:

And here is the formula tool using title case and the output:

Now the values will all fall under the same groups when you are doing your aggregations.

Hope this helps,

Tristan

[tristank]

Glad it has been resolved! Please mark it as solved for future users to find solutions.

Have a great week!

Tristan

[tristank]

Oh and remember that you can standardize case using the data cleansing tool too!

[Suedseeperle]

Great thank you for your help!