Using my SQL scripts in data schema expression

Question

Hello, I would like to use this function:

In the data schema declaration like this:

So its value is "prefix"

How can I do this?

Thank you in advance.

@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni

Amine_Abedour · Accepted Answer

Hello @heku_,

Please referre to this documentation to do what you want to do :

https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/api/adding-additional-sql-functions.html?lang=en

Br,

Amine

ParthaSarathy · Answer

Hi @heku_ ,Try this expression,expr="Substring(@email,0 ,Length(@email)-Length(GetEmailDomain(@email)))"<attribute expr="Substring(@email,0 ,Length(@email)-Length(GetEmailDomain(@email)))" label="Email Prefix" name="emailPrefix" type="string"/>Disconnect & Reconnect.

Sign up

Login with SSO

Login to the community

Login with SSO