UPDATE activity logic | Community
Skip to main content
A
at7140
Level 3
April 14, 2026
Question

UPDATE activity logic

  • April 14, 2026
  • 1 reply
  • 33 views

Hi All , 

i have field named as ‘good data’ in schema with boolean type as 0 and 1 . I have few records in schema with key as “@abc”.

there are cases where 2 records are present on same key with good data field values as 0{No}and 1{Yes} rest all field values are same. Now when i get new data file if record doesnot exist it should insert record with all field values(n number of fields)  passing in file and update good data field values as YES. and if record exist it should only update record in schema with good value as YES. It should not make any update changes to record with NO value. 

 

As we are prioritizing record with YES value only in workflow targeting. 

 

How i can implement this in single update activity

1 reply

SushantTrimukheD
SushantTrimukheD
Level 4
April 15, 2026

​@at7140 

What you want is:

  • If a record with the same @abc already exists and good data = 1, update that row.

  • If the only existing row has good data = 0, do not touch it.

  • If no row exists, insert a new one with good data = 1.

The important point

In Adobe Campaign, the Update data activity first needs to know which record is the match.
So you should match on:

  • @abc

  • good data = 1

That way, only the YES row is considered the existing row. Adobe’s reconciliation activity allows multiple rules, and all conditions must match for a record to be linked. The Update data activity then inserts or updates based on that reconciliation result.

Easy way to think about it

For the workflow, use this logic:

  • Find row where @abc = file.@abc and good data = 1.

  • If found, update it.

  • If not found, insert new row with good data = 1.

That is the behavior you want from Insert or update in Update data.

What not to do

Do not reconcile only on @abc, because then Campaign may see both the NO row and YES row as matches, and that creates ambiguity in duplicate-key situations.
Do not update the good data = 0 row at all.

Terms & ConditionsAccessibility statement

Loading footer...