Treatment of duplicated identifiers in target

vmsoothanan
vmsoothanan
in Modeling

How Treatment of duplicated identifiers in target works? I set it up "Reject entire import" But I see that List is getting updated? Can you please provide an example?

@Misbah image.png

Tagged:

Answers

  • AWhitworth
    AWhitworth

    Hi,

     

    You can get a full breakdown of the List import process here: https://help.anaplan.com/anapedia/Content/Import_and_Export/Import_Data_into_Models/Import_Data_into_Lists.html 

     

    the parts you are referring to are 11 & 12 

     

    1. Next, set the handling where two items in the source share the same import key value (that is, the name, code, or combination of properties selected in step 7). Under Treatment of duplicated identifiers in source select either:
      • Reject entire import
        If duplicates are found, the import is rejected and nothing is imported. This option will allow you to check your source data before running a potentially incorrect import. You can amend the data and run the import again.
      • Import first occurrence
        The default. Anaplan will import the first item found with the key and reject the second occurrence. Once the import is complete, you can view any items that have been rejected on the Details tab.
    2. You can now choose how you want to handle the situation where two items in the target share the same import key value (that is, the name, code or combination of properties selected in step 7). Under Treatment of duplicated identifiers in target select either:
      • Reject entire import
        This will identify any 'bad' keys and allow you to modify them before running the import again. (A 'bad' key is where you have two items with the same key value in the target list. For example, if you are importing an employee list and the key is 'first name' then the chance of encountering duplicates is high. Here, you could choose a key of 'first name' and 'last name' to ensure uniqueness.)
      • Reject duplicates only
        The default. Anaplan will reject any items that have a key value that is shared by two or more items in the target list. Any other items in the source will be imported as expected.

Categories