Update Recipient but ignore null input fields | Community
Skip to main content
K
karynf
Level 2
December 11, 2017
Solved

Update Recipient but ignore null input fields

  • December 11, 2017
  • 2 replies
  • 1649 views

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. 

    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 karynf

    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>

    2 replies

    vraghav
    Adobe Employee
    vraghavAdobe Employee
    Adobe Employee
    December 11, 2017

    Hi @karynf,

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

    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

      K
      karynfAuthorAccepted solution
      Level 2
      December 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>

      Terms & ConditionsAccessibility statement

      Loading footer...