Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to create a data flow using "Enter SQL" option to join two tables — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create a data flow using "Enter SQL" option to join two tables

Received Response
11
Views
2
Comments
edited Nov 12, 2019 3:19AM in Oracle Analytics 2 comments

Summary

I want to create a data flow by joining two tables and want to write the join statement using "Enter SQL" option

Content

Hi,

I want to create a data flow by joining two tables and want to write the join statement using "Enter SQL" option.

This gives me query error.

My requirement is to join tables vb_aggregated_access and vb_inventory_report and the query I am using is

select * from vb_aggregated_access a full outer join
vb_inventory_report b ON LOWER(a.POD_NAME)=LOWER(b.PSM_INSTANCE) ;

>gives me query error

Is there a way to do this in OAC?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!