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

SarthakGarg · 2025-01-14T11:18:49+00:00

There was an error rendering this rich post.

SarthakGarg

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

Accepted answers

All comments

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:

Clear the Flag LastFile from previous uploads
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
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

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

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…