Tableau practice: String cleaning and text normalization
Chapter 7 · 5 questions · included in full access
Question 1 · easy
Rep first name
Solve it in your browserCreate Rep First Name: extract the first word of the sales rep's name using
SPLIT([Rep], ' ', 1).Question 2 · easy
Product compound label
Solve it in your browserCreate Product Label: combine Category and Product separated by a colon and space:
[Category] + ': ' + [Product].Question 3 · easy
Tableau string indexing
Solve it in your browserUnlike Python or JavaScript which use 0-based indexing, what position index does Tableau use for string functions like
MID()andSPLIT()?Question 4 · medium
Standardized customer name
Solve it in your browserCreate Clean Customer: convert the Customer name to uppercase and strip accidental outer spaces:
UPPER(TRIM([Customer])).Question 5 · medium
Product code suffix
Solve it in your browserCreate SKU Number: extract the last 3 characters of the Product Code using
RIGHT([Product Code], 3).
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing