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

Is it Possible to use OR condition while joining dataset with Oracle DW Table

Sathyaprakash M

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

Find more posts tagged with

Accepted answers

Philippe Lions-Oracle

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

All comments

Philippe Lions-Oracle

Gianni Ceresa

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.

https://community.oracle.com/products/oracleanalytics/discussion/19322/option-of-creating-dv-workbook-based-on-combination-union-intersection-of-subject-areas-in-oac

Sathyaprakash M

Thanks @Philippe Lions-Oracle. When adding the column in Expression Filter, the filter value exceeds 1000; I am getting the error because of that.