Forum Discussion

PuddleRunna's avatar
PuddleRunna
Icon for Advocate I rankAdvocate I
5 years ago

Custom column that returns main eMail adress based on similar values

Hi all,   Coudln't even come up with a proper subject for this ðŸ™ˆ I've been stuck on this for ages.   I have a table "Employees" looking like this: First Name Name eMail Department Jane...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

PuddleRunna , Try new column like

 

new Department =
var _email = SUBSTITUTE([eMail], "_sec", "") // or use SUBSTITUTE([eMail], "_sec@", "@")
return
if(search("_sec", [eMail],,0) >0 , maxx(filter(Table, [eMail] =_email),[Department]),[Department])

PuddleRunna's avatar
PuddleRunna
Icon for Advocate I rankAdvocate I
5 years ago

Thanks a lot, Amit! This at least solves my problem for eMails that do not have numbers, which is the majority in this special case 🙂

 

Is there any way to make it look for eMail adresses that contain the substituted string and return the results?