Boolean Filter to match List Subset and List in Module

Highlighted
Occasional Contributor

Boolean Filter to match List Subset and List in Module

Hi

I am trying to create a filter to apply to 'INP Module - No of Frequencies' so that result below can be achieved but am hitting humps.

If the North Track and East Track in 'ss NE' matches the Track L2 column in SYS Module, then the Expected Result is that Serv under

North Track and Serv under East Track should appear under East Track.

 

lps_1-1591278384925.png

 

 

6 REPLIES 6
Highlighted
Community Boss

Re: Boolean Filter to match List Subset and List in Module

if you want to check that an item belongs to a subset, you have two create line items dimensionalized by these subsets, formatted as Bollean and with a formula = TRUE.

You can then check against these line items.

Do this in your list system module.

 

ps: it is important to name a subset with the following pattern: Name of the list - Name of subset

In your case it would be Track L2 - NE

this way when you are building in blueprint, you can clearly see what list is being used. While this may not seem useful for you now, it will in 6 months time when you'll have forgotten all about the model.


Nathan Rudman, Anaplan Model Builder
Highlighted
Certified Master Anaplanner

Re: Boolean Filter to match List Subset and List in Module

Hi @Nathan

I totally second your advice in naming the subset, especially that there isn’t an easy way to determine which list a subset belongs to in Anaplan as of now.
You can do a manual search through all the lists.
Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Master Anaplanner/Community Boss

Re: Boolean Filter to match List Subset and List in Module

Highlighted
Frequent Contributor

Re: Boolean Filter to match List Subset and List in Module

Hi @lps ,

 

You can create a filter and apply to the result module. for that you need to create filter module which is dimensioned by subset list and serv list. see the below screenshot.

 

naushad786_0-1591280344757.png

 

naushad786_1-1591280370224.png

naushad786_2-1591280405088.png

 

Hope It will help you.

 

Thanks,

Naushad

 

Highlighted
Occasional Contributor

Re: Boolean Filter to match List Subset and List in Module

Hi all
Thank you so much for your advice and suggestions. It works wonders.
Highlighted
Super Contributor

Re: Boolean Filter to match List Subset and List in Module

hi, you can use item(track)=system.track which will identify which serv is in which track  and then filter based on that