Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
How do I add a filter in OAC with a regexp_like condition?
Summary
I need to create a report in OAC by joining two tables based on regexp_like condition. How do I specify this in OAC?Content
Hello,
I've two separate datasets pointing to two different tables (Merged_DS_Table and Operation_List) in OAC.
I've created a report in OAC by including both the datasets and this has auto-created join between the two datasets based on the common columns between them (cs_method and cs_uri). Below is the query, it has internally used for the join condition
select * from Merged_DS_Table a, Operation_List b where a.cs_method=b.cs_method and a.cs_uri = b.cs_uri;
0