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

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

Update columns in a source
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
Is it not possible to have the same link in 2 dataspaces
We have 2 dataspaces (Training and Current), the training one had a link to a list in a Model. When i tried to add a link to the same list in the Current dataspace, the link showed as ticked and i could not select it. Does this mean you cannot link to the same source in 2 different dataspaces? It shows a tick in the LINK…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…