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 AI and Analytics

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!

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…

Top Leaders

Mallikarjuna Kuppauru-Oracle 80