Hi,I have a number of lists e.g. product list or employees list, but how is it best to maintain these as the list keeps growing, but we have products which are no longer active or employees who have since left?
Thanks
@CommunityMember113484
Once identified what needs to be deleted use Delete from List using Selection option and try to run it during off Business hours.
Ah! If it is only about showing the required products then you can create a matrix of Products and Versions and Write a formula in Boolean formatted line item Data <> 0.
Apply the filter based on the above Boolean formatted line item. This will display only those products which have values in current version.
Misbah
@CommunityMember113484,
The best way to manage your active and non-active list members is by having list subsets.
Create a subset in your product/Employee list and call it "ss: Active products" or "ss: Active users" and update these subsets based on actions/Manually.
Thanks,
Sandeep
@CommunityMember113484 The different solutions above will help you. I would use the subset approach in order to save space in these modules which do not need the whole list.
But the reason I am posting is to warn you about potential data loss: when a list item is removed from a subset, all the data stored for that item (i.e data which has been manually entered or loaded as opposed to data resulting from calculations) will be lost.
So just keep this in mind and make sure that you do not have Data Modules using the Subset, or, if you do, make sure that you can afford to lose the data related to the item which is going to be excluded from the subset.
Cheers
Alex
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
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…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
