Forum Discussion

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
1 year ago

Faster method for double boolean on filter?

Got this requirement that a source file contains per postal code a categorization. However, sometimes for a particular label, all postal codes are allowed. So I created something like this:   minx...
Tips and Tricks
DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
1 year ago

Why do you work with VAR's in this scenario? Aren't VAR's stored in memory during operation? Wouldn't that suck in capacity? 

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
1 year ago

DouweMeer 

When you use a variable, you avoid calling the field within filter on each interation, this way, you should see the code that I shared should show better performance. 

Did you try the measure?