While importing into system, how to highlight data already present in the module/list but

SarthakGarg
SarthakGarg
in Integrations and extensibility

While importing into system, how to highlight data already present in the module/list but not present in the file.

Tagged:

Answers

  • alexpavel
    alexpavel

    @SarthakGarg As far as I know, there is no default functionality to have this information.

    When you have situations like this, my solution is to build a system to flag of what is coming from the last file.

    When you import a file you could have in mind the below steps:

    1. Clear the Flag LastFile from previous uploads
    2. Import the file into destination. you could consider to build a "temporary area" (list or module) where you always have values imported from the Last File
    3. Import data into the final destination and also put a value into the Flag LastFile. All the values that do not have "Flag LastFile" with values means that data was uploaded previously.

    Hope it helps,

    Alex

  • mireille90
    mireille90
    edited February 7

    Use Anaplan Import and Data Action. During the import process, Anaplan will allow you to map fields from the file to your target module. If there is mismatch or missing data in the file, you can use the marking mechanism mentioned in step 1 to mark the missing data.

    @Sprunki Game

Categories