Categories
- All Categories
- 16 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Filter with an OR condition
Pavan Cheruvu-Oracle
Rank 2 - Community Beginner
I have two fields: Field A and Field B
I want to pull all records, which may have value 'SPLTAG' in either of the two columns.
How do I create a combination filter across two columns ?
Tagged:
0
Answers
-
Hi Pavan,
Welcome to Oracle analytics community.
Please try below:
SELECT * FROM table tab
WHERE (tab.A LIKE '%SPLTAG%' OR tab.B LIKE '%SPLTAG%' )
Thanks.
0 -
Tx for your inputs, Mandeep.
Field A and Field B are from different subject areas
Is there a way to get the OR condition on the Criteria tab of OTBI ?
0
