forums

Use these forums to ask questions and discuss Tableau.

Table Joins

Posted January 8th, 2008 by jasonlucey
in Data Sources and Performance

Hi,

Is there any way to text edit table join statements?

Thanks,

Jason

Add new comment

Comments

On January 9th, 2008 Dan Jewett said:

Hi Jason,

 There is, assuming your question is about an existing workbook and you want to change the tables/joins that are used in it.

Go to the Data/Tables menu and you will get a list of all the tables currently defined as part of your connection.  Pick one of the tables in the list and  select the Edit button on the bottom of the dialog, this will bring up a multi-tabbed dialog. The 2nd tab will be for Joins.  You can change the join type between inner/left/right/full (outer).  You can change the join operator from = to a different operator, and you can add new join clauses to include (or change) the join to include additional columns.

Hope this helps.

Dan 

reply