The Proper string function in Tableau | New in Tableau 2022.4

0:00In 22.4, Tableau have added a function that

0:03we all know in SQL but haven't had in Table

0:04au for a while,

0:06the proper function. Here you can see that

0:08I've actually got a table set up and I've

0:10already used

0:10it to create this full name field to find

0:13out how let's get stuck in. Before we get

0:15stuck in,

0:16just one quick favor, 82% of the people

0:19watching this video in the last year aren't

0:21subscribed to

0:22the channel. And just to show you some

0:24context, nearly half of my subscribers came

0:26from this last

0:27year's worth of content. And if you look at

0:29how many views and how much time people are

0:31spending,

0:31I'm sure it's creating value somewhere. So

0:33if you really appreciate the content or

0:35would like to see

0:36even more of it at a better higher quality

0:38standard, hit the sub button and enjoy the

0:40rest of the video. Okay, to show you this

0:42feature, I'm actually going to carry on

0:43where I left off

0:44in a previous video about image rolls. If

0:46you haven't seen that video, of course,

0:48check it out.

0:49I have a bunch of images here and I have a

0:50dashboard showing the first name of a bunch

0:53of

0:53users and characters in my organization. I

0:55'm actually going to break this table a

0:57little bit.

0:58I'm going to remove this and what I'm going

0:59to do is I'm going to bring in the column's

1:02last name

1:02and first name onto the table just to sort

1:05of set the context. And what you can see

1:07here is that I

1:08have a issue with the way the text is being

1:10handled. And so this is where the proper

1:12function

1:12is going to come in and help us. But whilst

1:14we're also here, what I'd love to do is I'd

1:17also love to

1:17bring in another column, which has people's

1:20specific jobs. You can see here that

1:22everything

1:23is in lowercase. And so before with Tableau

1:25, this was actually quite a pain to solve.

1:27And now with

1:28the proper function, it's dead easy. What I

1:30can do is I can essentially actually I can

1:32do a couple of

1:32I can do a couple of different things. I

1:34was going to go ahead and create a

1:36calculations,

1:36but I'll show you one step better. We'll

1:38double click on the text. And what we're

1:40going to do here

1:41is create an ad hoc calculation. So just by

1:43double clicking on the item, we can go in

1:46just type in

1:46the term proper, you can see the Tableau's

1:48auto complete here that you normally get in

1:50the

1:50calculation window comes up, it gives us a

1:53little brackets, we can just go ahead and

1:55wrap that around

1:56and enter. And boom, it's gone ahead and

1:58clean that data set for us. So you've seen

2:00the proper

2:01function in action. Just to show you what

2:03that looks like in an actual calculation

2:05field. Let's

2:05go ahead, create a calculated field. And we

2:08'll just go ahead and type it here, you can

2:10see that

2:10I also get the auto complete there. And

2:13this time I can say first name. And what we

2:15're going to do

2:16here is actually we're going to do the

2:18string calculation in here to do a first

2:19name last name

2:20combo. So if you haven't checked out my

2:22playlist on functions where I cover all of

2:24this, go ahead,

2:25I'll put a link to it in the description

2:27below. And but what we'll go ahead and do

2:29is go ahead

2:30and hit last name, we'll do that. And what

2:32we want to make sure we do between these,

2:34we add a little

2:35bit of a space in between these. So we're

2:38going to take the first name plus a space

2:40plus the last

2:41name to give us a first name last name

2:43combo. And then we'll go ahead and clean

2:45the fact that it's

2:46all in uppercase. And then we'll go ahead

2:48and call this first, we'll actually call

2:50this full name.

2:51Why not? Let's do that. Let's call this

2:54full name, hit apply. We'll see our

2:56calculations worked.

2:57We'll go ahead, drag it in after the last

3:00name. And there we go. We've got a bunch of

3:02first name

3:03last names, cleaned up nice and ready to go

3:05. So this proper function is been a long

3:08time coming.

3:09It's dead simple. It really is that simple.

3:11And you can add it inside a tab. Let's

3:13check out my

3:14playlist on functions. I literally covered

3:16a whole ton of functions that you should

3:17know in Tableau,

3:18going through the different categories that

3:20we have inside of Tableau. And this video

3:23is going

3:23to be part of that playlist. Thanks for

3:25watching, and I'll catch you in the next

3:26one.

3:27Transcribed by https://otter.ai

3:32[ Silence ]