Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
As a first step you will be interested by the "split email" processor (https://doc.dataiku.com/dss/latest/preparation/processors/email-split.html)
In your specific case, if the dot is present you can use a "split column" (https://doc.dataiku.com/dss/latest/preparation/processors/split.html) using a dot as delimiter.
Otherwise, you can use a formula with
substring(email, 0,1)