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

Lokesh Obhilineni-Oracle

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?

Ram-Oracle

@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.

Ram-Oracle

Please you may refer for case when statements usage https://docs.oracle.com/en/middleware/bi/analytics-desktop/bidvd/conditional-expressions.html#GUID-17D67DA8-DE8E-4C05-9B9F-4D0244B263CA

There are case(if) ,case(switch) statements which you may explore

Lokesh Obhilineni-Oracle

That worked perfectly

Thank you!