Skip to Main Content
Creating Data Stories with Tableau Public
book

Creating Data Stories with Tableau Public

by Ashley Ohmann, Matt Floyd
November 2015
Beginner to intermediate content levelBeginner to intermediate
218 pages
4h 54m
English
Packt Publishing
Content preview from Creating Data Stories with Tableau Public

The string functions

The string fields are often the richest in data source as they include other fields with free text, but they can also have the lowest data quality. The string functions in Tableau Public empower you to perform splice, trim, find, replace, match, reformat, and concatenate functions.

We will use several of these functions to clean up the floods data source, which was assembled manually and has several data quality issues.

The following are some of the most useful functions that we will use:

  • CONTAINS: This has a Boolean output. It tests whether a field contains the specified string.
  • FIND: This finds the place where a string of characters is located within a field.
  • LEFT, MID, and RIGHT: These often work in conjunction with FIND and ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Tableau 10 Complete Reference

Tableau 10 Complete Reference

Joshua N. Milligan, Tristan Guillevin
Tableau 2019.x Cookbook

Tableau 2019.x Cookbook

Dmitry Anoshin, Teodora Matic, Slaven Bogdanovic, Tania Lincoln, Dmitrii Shirokov

Publisher Resources

ISBN: 9781849694766Supplemental Content