How to get the domain name from Recipient table email address column?

[rvnth]

My target dimension is Recipient table and the filtering dimension I am using a custom schema.

I am trying to get the domain name from the custom schema which is linked with recipient schema as below in adding additional data > Output columns

Substring(@email,'@',-1)

Substring([recipient/@email],'@',-1)

However, I am getting an error. Please suggest

Thank you in advance.

[rvnth]

I found this. Please correct me if I am wrong.

I am targeting only gmail here.

Right(@email,9 )

[ParthaSarathy · Accepted solution]

Hi @rvnth ,

You can use GetEmailDomain() function in Query / enrichment expression to get the domain of email, and use it to map.

Example, GetEmailDomain([@email])

And also, in nms:recipient schema you can find OOTB attribute called email domain which will be using the same expression.