How do I convert Last known eruption(text) to year after 1900?
You can use
IF INT(LEFT(Your String,4) )>1900 THEN INT(LEFT(Your String,4) ) END
Thank you Deepak Rai
Great !!! if it worked can you pl close Thread by Marking my reply as CORRECT
I've marked it as correct!
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...