View Entire Topic
Hi @BelCDS ,
data type of @gender is "byte" (Integer 8 Bit) in Recipient schema.
Value of male is 1 and female is 2. (Value of None specified/unknown is 0)
In you are updating the gender using JOB import, then in your file change the gender format as 1 for male and 2 for female.
Select data type as integer (8 bit) for gender by clicking 'click here to change the file format' and follow the rest import JOB procedure. Gender field will get updated now.
Value of male is 1 and female is 2. (Value of None specified/unknown is 0)
In you are updating the gender using JOB import, then in your file change the gender format as 1 for male and 2 for female.
Select data type as integer (8 bit) for gender by clicking 'click here to change the file format' and follow the rest import JOB procedure. Gender field will get updated now.
Alternative way:
You can use a workflow to upload the file data in schema by using data loading activity.
Here, you no need to make the gender format as 1 for male and 2 for female in original file. you can have as 'male' and 'female' and need to remap this value as 1 and 2 in data loading activity.
You can use a workflow to upload the file data in schema by using data loading activity.
Here, you no need to make the gender format as 1 for male and 2 for female in original file. you can have as 'male' and 'female' and need to remap this value as 1 and 2 in data loading activity.
Regards,
ParthaSarathy S