Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Basic column conditional formatting with pattern match / "contains" operator
3276546
Rank 1 - Community Starter
Hi,
I'm trying to set a conditional format on a column if it contains some text. Is this possible? The GUI does not give "Contains All" or "Contains Any" as an operator.
Solutions I have tried and failed:
- Creating a second column to base the condition on (e.g. case when X contains Y then 1 else 0 end). The field is the measure of a pivot table and so a second column will not work.
- Editing the XML. I tried changing the code from <sawx:expr xsi:type="sawx:comparison" op="equal"> to <sawx:expr xsi:type="sawx:list" op="containsAll"> but no luck.
Is there a different XML format or another way to do this?
0