Create subset in list based on subset from another list

Hi,

I have a List 1 where one of its properties from List 2

In List 2, I have a subset which is manually created and not expected to change

I need to create a subset in List 1 such that it will be automatically checked based on the subset ("GE" in pic above) in List 2. how can I go about doing it?

Accepted answers

All comments

TimWard70

Unfortunately, List SubSets can only be updated manually or via an action. To keep the subsets aligned you will need to set up a module which has a saved view you can import into the LIST2 subset and set up an action to do this - you can then schedule the action to run periodically via cloudworks, or publish the action to a button in the UX

Kanishq17

Hi @Zhiying

Well list subset cannot be automatically checked , however you can create an import to load valid items of that list 1 which satisfy the subset of list 2 .

Basically you can find which items in list 1 are valid for the subset based on the list 2 formatted property and then use a filter to create a view for list 1 which shows only those items which are valid , then import in the subset

Zhiying

Hi @Kanishq17 @TimWard70 ,

May I know what should be the dimension of the mapping module? The formula of the mapping module should refer to even another module?

Ivan_Lo_

Here is a suggestion:

Module with List 1 as dimension

Line item	Format	Formula	Applied to: List 1
MAC	list formatted as List 2	List1.MAC
GE	list formatted as List 2 subset (GE)	FINDITEM(GE, name(MAC))
In List2 Subset?	Boolean	ISNOTBLANK(GE)

Create a module view by sorting "In List? Subset?" = True, you can find all the "List 1" items with "List 2" properties belong to subset "GE".

Then, create an action to import the boolean "In List2 Subset?" to update the check box of the new subset in List 1

Please let me know if it work.

Thanks.

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…