How do you exclude a value based on result name?

[Dom]

Hello,

I need to exclude a few values based on the value name. I'm assuming that I would use the filter tool.

[MarqueeCrew]

Did you try something like:

[Field_1] IN ('Black', 'White')

Within your FILTER tool?

[Dom]

I used this in my filter tool but the export file only include these result values. I want these 3 result values excluded on the output file.

[AnalyteName] IN ('Feet', 'Inches', 'Blood Pressure')

[RodL · Accepted solution]

You can either use the "NOT IN" function, or just pull the data from the False side of the Filter tool.

[MarqueeCrew · Accepted solution]

If you are trying to exclude, you could either connect to the FALSE connector or change your formula to:

[AnalyteName]  NOT IN ('Feet', 'Inches', 'Blood Pressure')

[Dom]

How would you use this filter with a concat_value?

[MarqueeCrew]

If you have a concat field created, then you might use a filter and the CONTAINS function.

CONTAINS([AnalyteName],'Feet')

||

CONTAINS([AnalyteName], 'Inches')

||

CONTAINS([AnalyteName], 'Blood Pressure')

I would suggest the use of a FIND & REPLACE tool instead.  If your list of terms is flexible, this solution would allow you the ability to maintain the list outside of the workflow.  The lookup is very fast and you can add the found term to the record if you wanted to know which term (single) that you matched on.  You could filter after the lookup on the "Appended" field being null (no match).  

Thanks,

Mark

[Dom]

I just added a filter with the expression  [AnalyteName] IN ('Feet', 'Inches', 'Blood Pressure') connecting from false right before my concat_value; that worked. Thank you.