Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data sources with different upper/lowercase letters

Suedseeperle
6 - Meteoroid

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_0-1686588303607.png

 

5 REPLIES 5
Suedseeperle
6 - Meteoroid

Titlecase([_CurrentField_]) works

tristank
10 - Fireball

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:

 

tristank_0-1686588606991.png

 

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

tristank_1-1686588638935.png

 

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

 

Hope this helps,

Tristan

tristank
10 - Fireball

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

 

Have a great week!

 

Tristan

tristank
10 - Fireball

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

 

tristank_0-1686589243742.png

 

Suedseeperle
6 - Meteoroid

Great thank you for your help!

Labels