Exclude from List

ColinHaze · 2023-11-03T13:19:57+00:00

There was an error rendering this rich post.

Hi,

Simple question.

I am trying to exclude values that contain a certain word in the beginning of the string.

How would I write that as a beastmode? I know I could write a lengthy case statement saying Case where Bill_To <> 'Location A' then 'Include, Where bill_to <> Location B then Include, Etc…

Find more posts tagged with

Accepted answers

GrantSmith

CASE WHEN `Bill_To` LIKE 'PREFIX%' THEN 'Ignore' ELSE 'Include' END

All comments

GrantSmith

CASE WHEN `Bill_To` LIKE 'PREFIX%' THEN 'Ignore' ELSE 'Include' END

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of