3 Replies Latest reply on Feb 8, 2019 10:05 AM by maneesh.gaddam

    How to filter on data type (ex: keep only valid emails or filter out invalid zip codes etc.)

    Numa Roch

      Hi,

       

      After specifying of which type a data field is (here in my case email), beyond displaying valid and invalid values, I wonder how one can filter out invalid data. Not manually (there are too many) but with a formula or any other method.

      In the screenshot below for example I would like to keep only valid emails.

      Filter on data type in tableau prep.PNG

      Many thanks in advance.