14 Replies Latest reply on Nov 13, 2018 4:29 AM by Nic G

    Calculated Field on Substrings

    Nic G

      Hi

       

      I wish to recreate the below SQL, what's the cleanest way to do this in Tableau? Do I have to make two new fields with the newly manipulated name, if so how do I write that one equals the other (this is one datasource so I don't think I blend) ?

       

       

      SUBSTR(ax.gsan_system_id,1,10) = SUBSTR(logical_storage_unit_name,8,10)

       

      (From Character 1 take the first 10 Characters from gsan_system_id) = (From 8th Character, extract the next 10)

       

      TIA