Create subset in list based on subset from another list

Options
Zhiying
Zhiying Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & Modeling

Hi, 

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

Zhiying_0-1653306389445.png

 

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

Zhiying_1-1653306425669.png

 

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?

Tagged:

Comments

  • Zhiying
    Zhiying Member, ALL USERS Posts: 5 Occasional Contributor

    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_
    Ivan_Lo_ Member, ALL USERS, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    Here is a suggestion:

     

    Module with List 1 as dimension  
        
    Line itemFormatFormulaApplied to: List 1
    MAClist formatted as List 2List1.MAC 
    GElist formatted as List 2 subset (GE)FINDITEM(GE, name(MAC)) 
    In List2 Subset?BooleanISNOTBLANK(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.

Categories