Question:
A user is trying to update the email addresses for some Health Care Provider (HCP) Profiles in Veeva Network because they are in an incorrect format. The Source Subscription runs successfully. Why is the email field not blank afterwards? Instead, the value of #N/A is displayed, although the user leaves the email_1__v field blank in the .csv file used for the Source Subscription.
Answer:
In the Source Subscription Advanced Mode, the user defines a keyword by which the user can null the values of the desired field: "parser.csv.nullstring[.ALIAS]": "<string>"
Checking the Advanced Mode of the Source Subscription that the user wants to update the Profiles with, it shows the following: "parser.csv.nullstring": "#NULL#".
The user needs to enter #NULL# to the email_1__v fields in the .csv file to clear the values on the Profiles.
Related Documentation:
Network Online Help: Advanced subscription settings