Data loading activity in v8 | Community
Skip to main content
K
KD1-1
Level 3
January 27, 2025
Solved

Data loading activity in v8

  • January 27, 2025
  • 1 reply
  • 660 views

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.

@parthasarathy 

Best answer by ParthaSarathy

Hi @kd1-1 ,

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 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
January 27, 2025

Hi @kd1-1 ,

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.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    K
    KD1-1Author
    Level 3
    January 27, 2025

    Hi @parthasarathy 

    Thank you for the quick reply, it really helped.

    Further can you please guide for below options also in data loading activity.

     

    Name of the file to load

    1.Specified in the transition

    2.Calculated

    3.Pre-process the file

    4.Create a view for file

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity Advisor
    Community Advisor
    January 31, 2025

    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.

    ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      Terms & ConditionsAccessibility statement

      Loading footer...