I have a calculated string field that looks like this:
And what I'm trying to do is if the first 6 characters of the string are "122016" then return the entire string of 122016_123456. Any idea how to do this?
Something like IF STARTSWITH([calculated string field], '122016') THEN [calculated string field] END should return what you want.
use left function to get the first n characters. See below screen shot for reference.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...