Configure multiple filters at once

kfaz81

I feel like this should be a simple question, but I can't figure it out (newbie here).

I need to apply 50 different filters to my data within my workflow. Instead of creating 50 different filters, is there a way to configure multiple filters at once? Thank you!

Below is a sample of the data I'm trying to filter:

CustomerResponseCode	AccountResponseCode
	3333	3333 only
CA11	5555	CA11 AND 5555
CA11	1111	CA11 AND 1111
CA23	1111	CA23 AND 1111

vizAlter

@kfaz81 — The Formula will create a new field, then once you configure the Output tool like the screenshot below, you it will generate Excel file with multiple sheets.

I have given the new column name as "Found_Status":

IF !IsNull([ns1:CustomerResponseCode]) AND !IsNull([AccountResponseCode]) THEN 
 [ns1:CustomerResponseCode]+" AND "+[AccountResponseCode] 
ELSEIF !IsNull([ns1:CustomerResponseCode]) AND IsNull([AccountResponseCode]) THEN 
 [ns1:CustomerResponseCode]+" Only"
ELSEIF IsNull([ns1:CustomerResponseCode]) AND !IsNull([AccountResponseCode]) THEN 
 [AccountResponseCode]+" Only"
ELSE 
 "Null Fields" 
ENDIF