nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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?

Find more posts tagged with

Accepted answers

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.

All comments

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!