Visualize new list items after import

Highlighted
Occasional Contributor

Visualize new list items after import

Hello,

 

We have a list of Skus that is the child of a Packaging list. Each packaging has multiple Skus.

Some Skus are old and are no longer active on our production lines. We have a module made of boolean line items to select which skus are "used" currently. 

When we update the sku list with new skus, by default that "used" boolean is set to False. So we have to go through the list of skus to kind of guess which ones are new and should be set to True. This is pretty problematic because it is easy to forget to check.

I do not want to reset the boolean each time to True because I cannot go back each time to uncheck all the old ones. 

Any ideas on how to handle this?

Ideally I would have a way to clearly see which skus are "new" and need to be checked or not.

 

Thank you for your help,

Message 1 of 5
4 REPLIES 4
Certified Master Anaplanner

Re: Visualize new list items after import

Hi ELISA,

check this link, this post is similar to yours.
https://community.anaplan.com/t5/Anaplan-Platform-Discussions/New-member-or-parent-change-flag/m-p/4...

Regards,
Vignesh M
Message 2 of 5
Occasional Contributor

Re: Visualize new list items after import

Hello Vignesh,

 

Thank you for your response, the link in the discussion you provided does not work anymore, could you send me the updated one?

https://community.anaplan.com/t5/Best-Practices/Building-a-Data-Hub/ta-p/33593#toc-hId--1989322620

 

Thank you,

 

Elisa

Message 3 of 5
Certified Master Anaplanner

Re: Visualize new list items after import

Hi ELISA,

It appears this link is not available anymore.


Follow the steps,

Step 1 : Create Checksum and Checksum Old line item, both are text formatted.
               Checksum = Name(Item(List))
               Checksum Old (No formula), Input field
Step 2: Create one action to import data from checksum to checksum old line item.
Step 3: Create Boolean format line item
             New Item Flag? = Checksum <> Ckecksum old.

After this follow the below order
1. Load data into your list
2. New records will be highlighted as TRUE in New Item Flag? line item
3. After you done your validation, Run the import action which will copy data into checksum old to reset the boolean.

Regards,
Vignesh M

Message 4 of 5
Occasional Contributor

Re: Visualize new list items after import

Thank you, it worked!
Message 5 of 5