Advanced expression editing in Update Data > Return an empty string | Community

Solved

Advanced expression editing in Update Data > Return an empty string

Forum|Forum|5 years ago
November 25, 2020
3 replies
2273 views

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 🙂

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by ParthaSarathy

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.

Regards,

ParthaSarathy S

Community Advisor

Community Advisor

Hello @amandined

You can try this code.

Case(When(COLUMN="unknown",''),Else(COLUMN))

Let me know if that works

Manoj Find me on LinkedIn

Community Advisor

Accepted solution

Community Advisor

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.

Regards,

ParthaSarathy S

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

AmandinedAuthor

Thank you for your help!

I found also another solution.

In the "load file" activity I added for each column a "correspondence" :

if value = unknown then empty value