CASE WHEN using IN

I am trying to filter my records by specific accounts. I am using beat mode to try and do the following:

CASE WHEN `Company Name` IN('COGNIZANT', 'AARP') THEN 1 ELSE 0 END

Then I use this as a filter set to 1 hoping to only return the accounts I am looking for.

 

When I run this I never get any accounts returned.

 

Any input would be greatly appreciated

Comments

  • BlueRooster
    BlueRooster Domo Employee

    Are there any inconsistencies in the names that you're aware? (Is it possible you have leading or trailing spaces?)

     

    The other thing you could try would be this:

    CASE WHEN `Company Name` LIKE '%COGNIZANT%' 
    OR `Company Name` LIKE '%AARP%'
    THEN 1
    ELSE 0
    END

    Hope this helps,

    ValiantSpur

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

  • I am not sure what is going on but I keep getting validation error. I have a list of about 2000 accounts that I am trying to query for. Maybe this isn;t the best way to go about it.

     

    What I am trying to do is match Company Name from my file to Compnay Name in the data and return fields limiting the data to those accounts.

     

    Is CASE WHEN the right way to about this.