Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Making the data to uppercase

Pramod91
8 - Asteroid

How can I change the data in columns from lowercase to uppercase. Example of data:-

 

Assessed

Recommended | Recommended

NA

NA | NA | NA

1 REPLY 1
Kenda
16 - Nebula
16 - Nebula

Hi @Pramod91 

 

Simply add a regular Formula tool and use the following expression:

Uppercase([Field1])

Where [Field1] is the field that you want to make upper case.

 

 

If you want to do this to multiple fields at once, use a Multi-Field Formula tool with this expression:

Uppercase([_CurrentField_])

and use the check boxes at the top of the configuration window to select which fields to make upper case.

Labels
Top Solution Authors