Tableau - How to Unpivot and Process/Count Data in a Single Cell

To get your FREE Tableau Beginner Training course, check out my website at:
www.udemy.com/course/tableau-...
-----------------------------------------------
SUBSCRIBE for new videos Tuesday-Thursday. Click the notification bell so you don't miss a single episode.
GOT A QUESTION/PROBLEM? Why not request a video using the Comments section below. I'll make a custom video just for you.
----------------
VIDEO DESCRIPTION:
This video goes out to Ravishankar!
There are cases whereby different types of data are stored in a single cell. the problem is that you need to split the data out prior to performing any analysis.
The simplest example is an address such as "Unit 1, 15 Remington Street, 4000, SA". Say you have 1000 rows similar to this structure. In order to count how many in each state, post code, or how many are in units, you need to split the data out first.
In cases where the data is consecutive as is the case Ravishankar, you'll need to add a pivot step. For example, for a given record you have multiple values across months.
Student Name | January | February | March
Jed | 50 | 20 | 15
In this video, I'll show you different ways to process this data using different softwares within Tableau and outside of Tableau.
----------------
TRAINING COURSES:
Udemy - Complete Tableau Training Course
-Over 184k students and over 13k reviews!
-200 Lectures and 22 hours of Tableau Content
www.udemy.com/course/tableau-...
SkillShare Tableau Training
www.skillshare.com/profile/Je...
------------------------------------------------------------------
CZcams PLAYLISTS:
Tableau for Beginners - A Quick Start CZcams Course
• Tableau for Beginners ...
Tableau Desktop Accelerator CZcams Course - A Beginners Guide for New Users
• Tableau Desktop Accele...
Tableau Online/Server Short Course - Site Creation, User Management and Licensing
• Tableau Online/Server ...
Tableau Online/Server - Complete Playlist
• Tableau Online/Server ...
Tableau Desktop - Complete Playlist
• Tableau Desktop - Comp...
Tableau Prep - Complete Playlist
• Tableau Prep - Complet...
#Tableau
------------------------------------------------------------------------------
RECORDING EQUIPMENT (Amazon Affiliate Program) -
VIDEO DESCRIBING EACH ( • My Recording Equipment... )
Headset: Sennheiser GSP 350 - Dolby 7.1 Surround, Noise Canceling, headset volume control
amzn.to/32N8vpz
Keyboard 1: Logitech Illuminated K830 Wireless Keyboard with Touchpad
amzn.to/2IIcHzn
Keyboard 2: Logitech MX Wireless Illuminated Keyboard
amzn.to/36BAIk4
Mouse: Logitech MX Master 2S
amzn.to/32KMaso (My current model)
amzn.to/2IF5C2G (Latest Model MX Master 3)
Laptop Stand: Adjustable/Tilting Laptop Stand Aluminum
amzn.to/2Uuj7F7
Monitor: BenQ 1080P 24-Inch Monitor
amzn.to/2Usen2T
Webcam: Logitech C920 HD Webcam 1080P
amzn.to/3kz7Ca3
LED Studio Lights: x2 Neewar 660 LED Video Lights with Barn Doors, Stand, Bag and Dimmer
amzn.to/3f3tuJr
Camera Tripod: Manfrotto Advanced Tripod 3-Way Head with Quick Release
amzn.to/3pvmg5V

[@user-mg1io9so4k]

Very helpful video for beginner users like me. Thank you for this!

[@saydeeztee]

What if you want to unpivot? I have a situation where I have to split the field in order to do a join but then need to aggregate the joined field with a delimiter.

[@michellebannon674]

Another informative video. Can you save the Tableau Prep files and structure so that if you refresh the data and want to run all the steps it will do it or will you get all the Exclamation marks that indicate somethings not the same?

[@jellymaneducation6168]

Hey Michelle, I've filmed a new video for you :) czcams.com/video/BVZfL-3DLVY/video.html

[@michellebannon674]

@@jellymaneducation6168 You're the best! Thank you.