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 ]
Tableau | Data visualisation | Data prep