Adobe Campaign Standard

AndrewJo5 · 10/1/24

In ACS, how can I use the enrichment activity to swap the value of an original field (from a CSV load) to a destination field in a profile so that a Yes becomes a No and a No becomes a Yes?

SatheeskannaK · 10/1/24

@AndrewJo5 An easy approach would be while loading the data using File Load activity map the behavior of the data import to say when the value is Yes to No and vice versa. If you want to use that in enrichment activity use the functions Iif and setBit to have that changed. Something like below and update that with update activity.

Example: Iif(@emailOptStatus=1, SetBit(@emailOptStatus, 0), 1)

Thanks, Sathees

View solution in original post

SatheeskannaK · 10/1/24

@AndrewJo5 An easy approach would be while loading the data using File Load activity map the behavior of the data import to say when the value is Yes to No and vice versa. If you want to use that in enrichment activity use the functions Iif and setBit to have that changed. Something like below and update that with update activity.

Example: Iif(@emailOptStatus=1, SetBit(@emailOptStatus, 0), 1)

Thanks, Sathees