It would be great if there was a way to keep only valid values from a step.
For example, If I have a field where I let Tableau Prep know that it is an email data role it can then tell me if a value is valid or not.
I can select Show values that are not valid.
But I'm not able to automatically filter these values out. It would be great to have a filter so that when the flow is run and new values populate and are not valid, they can be excluded without me having to manually check the step each time before running the flow.
Hi Jason,
this would indeed be a nice addition to Prep.
In the meantime you could create such a filter yourself by imitating the 'validaate email' functionality' by a calculated field:
REGEXP_MATCH([email],"[\w-]+@([\w-]+\.)+[\w-]+")
which returns true or false - if you filter your flow on 'true' you only get records with valid email values.
Does this help you out?
Kind regards,
Johan de Groot
