Skip to content

    • Magic ETL

    Magic ETL

    Is there a way to use the LIKE operator to make it case insensitive, specifically in the ETL?

    Member
    in Magic ETL

    I have looked through the Community Forum trying to find a way to make LIKE case insensitive. I came across a way using ILIKE in the formula tile, but after trying it I found that it didnt work in the Formula. I am specifically looking for a way in the Filter tile.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      Answer ✓

      Yes. you should be able use the LIKE operator in the filter tile. I would add the LOWER or UPPER function to make it case insensitive. Adding the % sign around your string will make it a wildcard search. Like this:

      LOWER(statename) LIKE '%tex%'

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.

    Answers

    • Coach
      Answer ✓

      Yes. you should be able use the LIKE operator in the filter tile. I would add the LOWER or UPPER function to make it case insensitive. Adding the % sign around your string will make it a wildcard search. Like this:

      LOWER(statename) LIKE '%tex%'

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Contributor

      I think if you wrap the field in UPPER, and the string pattern after LIKE is uppercase, this should accomplish what you want. Works for LOWER and lowercase, too.

    • Member
      https://community-forums.domo.com/main/discussion/comment/94847#Comment_94847

      Thank you for your thoughts on this matter, I ended up getting the ILIKE operation to work I forgot to include the % in my quotes. Thank you for the fast response

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories