Multi-Output Filter

Question

Hi,

I have a dataset from which I need to filter certain values from one column. The values that need to be filtered change every month. Is there a filter tool that would output multiple different tables from the original input file rather than the true and false values? For example, could I filter for A, B, and C and have output the rows that meet these 3 criteria from one filter tool?

Thanks.

DawnDuong · Answer

hi @qasdxx

Not sure if I understand your use case 100%. If you are trying to output different tables depending on certain pre-defined conditions, one way to do that is:

Step 1: Add a new column that categories your records. E.g. If A, B C then 1 else 2 endif....

Step 2: use the Output file with the option "Take File/Tab name from field".

Dawn.

Christina_H · Answer

A filter tool can only have two outputs, however there's almost certainly a way to do what you want.  It's not entirely clear what you are trying to do though.

For example, you could update the filter to output all records matching one of the criteria, [Field]='A' OR [Field]='B' OR [Field]='C', then group your output into separate files for each in the output tool: