Remember field status before importing new data

Hello,

We import a rolling 4 week view of orders (from external) into a numbered list very week, this list is then used as a soruce for a model. In the module there is a booelan for 'approved' the user ticks orders that are aproved so they dont have to check again.

We clear the list each week and import fresh data. I want to keep the approved Boolean for any previous ticked orders. I have tried to export to another numbered list, but then can not get it back. I am sure this should be simple but am stuck. Any suggestions please?

Accepted answers

bdeaton

You will have to import directly into the CODE field when you import. To my knowledge there is no way to set up a formula to pull in the data to the CODE field after the fact in Anaplan (I suppose you could use a two-step import in Anaplan to import your data, set up a property with the concatenation, and then import to a second table).

DavidSmith

Agreed, unless you can bring the code in on the initial import, the only way is to create the code in a module dimensioned by the numbered list, as described, and then run a second import to the list, just to populate the code

What you could then do is create a normal list to hold the history using the code and match the two lists that way using a finditem

David

All comments

bdeaton

How are you identifying items as unique? Through the system generated number, with the code, or a combination of properties?

If you can use a code (we usually create a unique key that's a concatenation of the properties and assign that as the code), then should be able to associate the code in your orginal list with your secondary list and I think you are on the right track with your import to another numbered list. You can then just import the boolean field back from your secondary list to your primary based on matching up the code.

DavidSmith

As @bdeaton says, using a code is best practice if possible

Also, it is better not to delete all of the items each time, but try and only import those new items. That would resolve the issue matching the old and new "ticks"

David

DeveloperCYT

I can concatenate 2 fields to give a unqiue reference. How do i get that in the CODE. Sorry, i am really struggling with this, it's one of those things, do once and very useful.

I have 2 fields in the module joined now called uniqueRef, and i have exported this to a list where approves = TRUE.

Now i am in the module which has the uniqueRef and i want to pull in the approved boolean, but i can not use LOOKUP or FINDITEM, so how do i pull it back.

Thanks so much

DeveloperCYT

The problem is that they do not want an ever growing list, they just want a rolling 4 week view, otherwise it grows and grows and becomes unmanageable.

But as each 4 week rolling has 3 previous weeks, thye want to keep anything they already approved, and the rolling data can change, so we can't just add the latest week.

nothing is ever simple

bdeaton

DavidSmith

What you could then do is create a normal list to hold the history using the code and match the two lists that way using a finditem

David

DeveloperCYT

Thank you both, i have my approved list saving and bringing back in succesfully.

Many thanks

Quick Links

Can you help?

Unanswered questions

Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…