Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Advanced expression editing in Update Data > Return an empty string

Avatar

Avatar
Validate 1
Level 1
Amandined
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
Amandined
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Amandined
Level 1

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 🙂

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 5
Level 4
ParthaSarathy
Level 4

Likes

34 likes

Total Posts

61 posts

Correct Reply

26 solutions
Top badges earned
Affirm 5
Establish
Give Back
Boost 5
Boost 3
View profile

Avatar
Affirm 5
Level 4
ParthaSarathy
Level 4

Likes

34 likes

Total Posts

61 posts

Correct Reply

26 solutions
Top badges earned
Affirm 5
Establish
Give Back
Boost 5
Boost 3
View profile
ParthaSarathy
Level 4

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

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 1
Amandined
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
Amandined
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Amandined
Level 1

27-11-2020

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

 

Capture.JPG

Avatar

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

111 likes

Total Posts

309 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

111 likes

Total Posts

309 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile
_Manoj_Kumar
MVP

25-11-2020

Hello @Amandined 

 

You can try this code.

 

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

 

Let me know if that works