Multi choice filter

MarkGi

Hi

I am trying to filter out rows using the Filter tool where there are multiple strings to use.  Looking at other posts I thought the following ought to work for string data:

[Account Number Categ] != ("Internal Allocations" , "Customer Allocations" , "IM Management Allocation" , "Cost Drivers" , "Undefined" , "IM Settlements")

However when I run it i get Error: Filter (55): Parse Error at char(50): Unmatched (

I must be missing something in the syntax ?

thanks, Mark

rzdodson

@MarkGi you are pretty close to solving it. Here is what I would do in your filter tool.

[Account Number Categ] IN('Internal Allocations', 'Customer Allocations', 'IM Management Allocation', 'Cost Drivers', 'Undefined', 'IM Settlements')

Those  Account Number Categ records that match those strings will fall out of the True anchor of your Filter tool. Those that do not will fall out of the False anchor. The advantage of the above is that you can either add strings to the IN clause similarly to how you would in other syntax languages (e.g. SQL), and it potentially gives you the ability to transfer the workflow in to an Analytic App where you can dynamically select the types of Account Numbers for your analysis should you need to get different data sets.