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]

Is this possible and if it is how would this work?

[Amanjotsingh Gill]

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.

[Adam Meltzer]

I tried that and I received the message below.

Failed to execute query: ORA-00942: table or view does not exist

 (HRESULT: 80131500)

[Amanjotsingh Gill]

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