SOLVED
Data loading activity in v8
Hi Adobe Team,
I am using the Data Loading activity in Adobe Campaign Classic v8, which includes a column for studentid. Upon analyzing the data, I noticed that the studentid column contains blank values.
I have configured the following settings:
Allow Null: Set to "Always populated."
Error Processing: Set to "Ignore the value."
However, I observed that the entire row is being rejected instead of ignoring the blank value and processing the other column values. I am unable to understand how the error processing works, despite reviewing the Adobe documentation.
Could you please provide clarification on the following error processing options and how they function?
1. Ignore the value
2. Reject the line
3. Use a default value in case of error
4. Use a default value in case the value is not remapped
5. Reject the line when there is no remapping value
Thank you for your assistance.
1 Accepted Solution
Correct answer by
Hi @KD1 ,
Consider there is a Integer field defined as below and allowing empty values, and consider the file has a string value instead of integer for this field,
1) Ignore the value : This will replace the string as 0.
2) Reject the line : This will reject the entire row for the particular record where the value is string instead of integer and process rest of the all other valid row data.
3) Use a default value in case of error: This option is same as 'Ignore the value', but instead of replacing it with 0, it allows you to predefine what value you can replace incase of error / invalid data.
Consider the example: If the file have a column 'Gender' but values in it are 0 for Male, 1 for female. So we can make remapping as below,
But if the file has other values as 3 or 4 which is not mentioned in remapping, then the output will be as 3 or 4. To handle this situation utilize below options,
4) Use a default value in case the value is not remapped: This option enables to enter a value (Example: None specified). This will replace 3 and 4 in the file with gender as None specified
5) Reject the line when there is no remapping value: This will reject the entire row for the records where the Gender value is either 0 or 1.
Correct answer by
Hi @KD1 ,
Consider there is a Integer field defined as below and allowing empty values, and consider the file has a string value instead of integer for this field,
1) Ignore the value : This will replace the string as 0.
2) Reject the line : This will reject the entire row for the particular record where the value is string instead of integer and process rest of the all other valid row data.
3) Use a default value in case of error: This option is same as 'Ignore the value', but instead of replacing it with 0, it allows you to predefine what value you can replace incase of error / invalid data.
Consider the example: If the file have a column 'Gender' but values in it are 0 for Male, 1 for female. So we can make remapping as below,
But if the file has other values as 3 or 4 which is not mentioned in remapping, then the output will be as 3 or 4. To handle this situation utilize below options,
4) Use a default value in case the value is not remapped: This option enables to enter a value (Example: None specified). This will replace 3 and 4 in the file with gender as None specified
5) Reject the line when there is no remapping value: This will reject the entire row for the records where the Gender value is either 0 or 1.
1.Specified in the transition: If you're getting the file from file transfer / file collector activity, you can use this option.
2.Calculated: If the file name is calculated, example Input_File_<%= formatDate(new Date(), "%2D.%2M.%2Y") %>.csv
3.Pre-process the file: Say If you need to decrypt the input file, use this option
4.Create a view for file: To access the file from cloud if campaign is integrated with system such as AWS, use this option in data loading activity.
