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 ...
Get Creating Data Stories with Tableau Public now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
