From the course: Learning Data Analytics: 1 Foundations

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Changing case and replace values

Changing case and replace values

From the course: Learning Data Analytics: 1 Foundations

Start my 1-month free trial Buy for my team

Changing case and replace values

“

- [Instructor] We change case and data for a million reasons. For example, we might need to uppercase two letter abbreviations for state, or maybe names have been entered and sometimes they're uppercase and sometimes they're lower case and we want to convert them to proper case. We're usually doing this for consistency across our data. It's also important to note that Power Query is case sensitive. So if we're going to use tools like replace values sometimes to make it simple it's easier to convert to a different case. In our example here, we want to actually uppercase first name and last name. So let's go take a look at our data. I'm going to right click my sales order header and I'll choose edit. It is easy to convert this to uppercase. I can right click first name. I can get a transform. I see options for lower, upper and capitalize each word which the function equivalent of that is equal proper. So I'll go ahead and do upper case. If I know that I want to do multiple fields, I can…

Contents