Advanced expression editing in Update Data > Return an empty string

Avatar

Avatar

Amandined

Avatar

Amandined

Amandined

25-11-2020

Hello everyone, would you be able to help me to define an expression in an "update data" activity ?

 

I want to import a file containing values equals to "unknown". But for every values = unknown, I want to import an empty value in Adobe Campaign. So I need to create an expression that convert a value = unknown into a empty string in adobe.

 

I know there is the expression "NoNull <Value>" that returns an empty string if the argument is NULL, but I would like to do the same if the value = unknown.

 

Thank you for your help 🙂

View Entire Topic

Avatar

Avatar

ParthaSarathy

Avatar

ParthaSarathy

ParthaSarathy

25-11-2020

Hi @Amandined ,

Let's consider firstName is your column which has value as 'unknown'.

This will help you, first it will check for value, if it is 'unknown', then it will make the value as empty string in DB. 

unknown.PNG

Regards,

ParthaSarathy S