Change the value from Yes to No when loading profiles

[AndrewJo5]

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]

@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)