Jump to content
We've recently updated our Privacy Statement, available here. ×

I am trying to do a full outer join with two tables within a Join Path within the Information Designer. I am trying to match GROUPNUMBER with both tables (%1 and %2) and STATEMENTDATE in the first table (%3) with EFFECTIVE in the 2nd table (%4).


Adam Meltzer

Recommended Posts

You can do full outer join by modifying the auto-generated SQL of an information link.

For example, you can start by creating the information link with an inner join. When the information link is working with the inner join, click the "SQL..." button, and use the "Edit SQL" dialog to modify the auto-generated SQL as needed to generate the full outer join.

Link to comment
Share on other sites

Error Ora-00942 is coming from the Oracle database meaning you are attempting to execute an SQL statement that references a table or view that does not exist. It looks external to Spotfire.

https://docs.oracle.com/cd/E11223_01/doc.910/e11202/testing.htm#BCGJGGEI

For more information about join creation in Spotfire: https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/id/id_creating_a_join.htm

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...