Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How can I implement Tableau’s `CONTAINS` function in Oracle Analytics Cloud?

Accepted answer
22
Views
3
Comments
Lokesh Obhilineni-Oracle
Lokesh Obhilineni-Oracle Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

How can I replicate the CONTAINS function from Tableau in OAC for text field searches?

To check if data in a field(column) contains the text that we are trying to find?

image.png

Best Answer

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics Lead
    Answer ✓

    @Lokesh Obhilineni-Oracle Hi Lokesh, Please pull calculated column and use case when statements along with like operator.

    example: case when New to clinic indicator like '%use your text keyword%' then <yes>

    else <No> End

    please see if it helps.

Answers