Filter Contains

[suby]

Sorry but I have created a new thread to avoid confusion and I have attached the excel sheet with the desired output.

please help me to get the desired output based on the same data.

Thanks

[suby]

1. Thanks for you reply in my example this will work and in real world is  there way to match the exact string Please.

[grossal]

Just throw your formula without the IF-Part in a Filter and it works: 

Workflow attached.

Best

Alex

[suby]

Thanks grossal and I want to create an additional column called ' Test'with yes or No flag can you please suggest if there is a way to do it.

[grossal]

You could do this in the way you already tried it to do. 

IF [Your Condition] THEN 'Yes' Else 'No' ENDIF

[suby]

Thanks I tried doing this way I removed the filter tool and inserted the formula tool with the below formula and it gives me this result set. attached the screenshot.

if [CODE] = "IM"
OR  [CODE] = "AS" 
OR [CODE]= "IMM"  then 'Yes' else
'no' endif

[grossal]

and what's the result you want?

[suby]

Thanks and the result set attached and this way I wanted my result

[grossal]

Result:

Check out the attached workflow.

Best

Alex

[suby]

Thanks but in my example data set I've  taken only where the condition satisfies 'Yes', what should I do if want to evaluate 'No' as well.

[grossal]

Just use the Data From the F-Anker to only get the 'No' data.

If want both, than just don't use a Filter Tool at all, but from your request, you said you look for the 'Yes' that's why I used it in the first place.