Exclude from List

Options
ColinHaze
ColinHaze Member
in Beast Mode

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…

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options
     
    CASE WHEN `Bill_To` LIKE 'PREFIX%' THEN 'Ignore' ELSE 'Include' END

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options
     
    CASE WHEN `Bill_To` LIKE 'PREFIX%' THEN 'Ignore' ELSE 'Include' END

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories