Product List - best way to not show products which are no longer active?

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

Accepted answers

All comments

Misbah

@CommunityMember113484

Once identified what needs to be deleted use Delete from List using Selection option and try to run it during off Business hours.

CommunityMember113484

I don't think this works when there may have been data against this product/employee in previous versions?

Misbah

@CommunityMember113484

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

SandeepB

@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

AlejandroGomez

@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

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…