Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Is it Possible to use OR condition while joining dataset with Oracle DW Table
Hi All,
I am trying to create a report based on the File and Table, and over there, I need to use an OR condition while joining multiple columns. Is it possible to achieve that in OAS/OAC?
My Condition is: In File, we have Customer_name and Passport columns, and I need to join the file with the customer table based on customer_name or passport.
My report should display the data based on the matched customer name OR passport number. Please let me know your suggestions/comments on achieving this scenario.
Regards,
Sathya
Best Answer
-
Hi @Sathyaprakash M , I don't think you can do this in the self service data modeling, I think you can achieve it either in an RPD (semantic layer to create an SA), or else, if the need is only for one report, you may be able to build an expression filter clause for this report that is based directly on a logical SQL. Not 100% sure but it should be possible. Let me know if you need help with that one
1
Answers
-
Adding on Philippe answer, if you don't want to go into building a full semantic model just for that "OR", you can do it in a dataflow and create a new dataset with the result of the OR join. And then use that where you need it. It could be a "quick win" (not ideal, not perfect, but does the job).
Another simple solution would be to make a UNION query in your DV workbook (so you can have a query with the first criteria and you then add the result of the query with the second criteria), but this isn't available right now: you can upvote the idea asking for it.
2 -
Thanks @Philippe Lions-Oracle. When adding the column in Expression Filter, the filter value exceeds 1000; I am getting the error because of that.
0
