Register

Multiple Text Exact Match Filter

CommunityMember118291
Contributor

Multiple Text Exact Match Filter

Hi All,

Is there a way, that we can return an exact match when we are searching multiple customers/accounts/texts in one text box.

 

Example - We have an assignment list to filter where assignment names can be like Assignment1 , Assignment21, Assignment19 and so on.

Now we have given end users a text box where they can search multiple assignments at the same time by just concatenating the assignment names with a Comma.


Now when the end user searches :  Assignmen1,Assignment21

 

Result returned is : Assignment1,Assignmen21,Assignment19 
This happened because we use FIND function which searches for contains when we search like this, as per the Anaplan Smart Filters.
Is there anyway we can make it an exact  match only and not contains?

5 REPLIES 5
MarkWarren
Expert

Re: Multiple Text Exact Match Filter

Why does this need to be done as a formula?
Could you not use the built-in filters (quick access toolbar) for grids to show the items?
Quick Access Toolbar - Anaplan Technical Documentation

CommunityMember118291
Contributor

Re: Multiple Text Exact Match Filter

Hi @MarkWarren ,

You are correct this can be achieved through quick filters, but this will be not be used solely for filtering but also act as a control to perform operations on the filtered assignments/rules without doing anything else(manually making the Boolean true for such assignments/rules).

The intent is to reduce the number of clicks business has to perform for making any adjustment to any rules/assignments.

Let me know if any more clarity is required.

rob_marshall
Moderator

Re: Multiple Text Exact Match Filter

@CommunityMember118291 

 

Instead of using text which is bad for performance reasons, why not use Booleans?

 

2021-02-01_07-26-43.png

 

Now, when you do the above, you will need to dimensionalize the above SYS Module by Users as well as a line item in the source data by users as well (where you put your filter).  How many users will be using this functionality?

 

Rob

CommunityMember118291
Contributor

Re: Multiple Text Exact Match Filter

Hi @rob_marshall ,

I am afraid this will not work as the assignment/territory list have 150-200k entries, and the end users can't manually check each Boolean, that is why they are asking for filters which will filter the assignment/territories and at the same time select them for any modification.

 

Let me know if any more clarity is needed.

rob_marshall
Moderator

Re: Multiple Text Exact Match Filter

@CommunityMember118291 

 

Why not use the search feature?  Anything will be better than using text, especially on lists of that size.

 

2021-02-03_07-33-20.png2021-02-03_07-33-39.png