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

Update Recipient but ignore null input fields

Avatar

Avatar
Validate 1
Level 2
karynf
Level 2

Likes

2 likes

Total Posts

6 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
karynf
Level 2

Likes

2 likes

Total Posts

6 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
karynf
Level 2

11-12-2017

For a technical workflow, is there an option or setting to update a schema record except when the import/source field is null - ignore null on import?  Example.  A recipient record exists with several fields already filled with data.  A new import record has some of those fields as empty/null.  The expected result is to update that Recipient record without overlaying existing fields with nulls. 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
karynf
Level 2

Likes

2 likes

Total Posts

6 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
karynf
Level 2

Likes

2 likes

Total Posts

6 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
karynf
Level 2

12-12-2017

I will try it. I thought that is what that option could be used for but I

could only find references not an actual example in the documentation.

On Mon, Dec 11, 2017 at 6:57 PM, Vipul Raghav <forums_noreply@adobe.com>

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

11-12-2017

Hi @karynf,

You can use the "Taken into account if" setting inside the Update data activity.

1370982_pastedImage_0.png

All you need is to put a condition that checks or NULL values and returns either true or false.

You will have to use this at each column that you suspect will be holding NULL values.

Please be aware that it will cause an overhead in processing of updates and hence take into account that extra time when scheduling your import workflows.

Regards,
Vipul