Outer

The explicit Join prefix can be preceded by the prefix Outer to specify an outer join. In an outer join, all combinations between the two tables are generated. The resulting table will thus contain combinations of field values from the raw data tables where the linking field values are represented in one or both tables. The Outer keyword is optional and is the default join type used when a join prefix is not specified.

Syntax:

Outer Join [ (tablename) ](loadstatement |selectstatement )

Arguments:

Arguments
Argument	Description
tablename	The named table to be compared to the loaded table.
loadstatement or selectstatement	The LOAD or SELECT statement for the loaded table.

Load script

Add the example script to your app and run it. To see the result, add the fields listed in the results column to a sheet in your app.

Table1:
Load * inline [
Column1, Column2
A, B
1, aa
2, cc
3, ee ];

Table2:
Outer Join Load * inline [
Column1, Column3
A, C
1, xx
4, yy ];

For more information about using inline loads, see Using inline loads to load data.

Resulting table
Column1	Column2	Column3
A	B	C
1	aa	xx
2	cc	-
3	ee	-
4	-	yy

Explanation

In this example, the two tables, Table1 and Table2, are merged into a single table labeled Table1. In cases like this, the outer prefix is often used to join several tables into a single table to perform aggregations over the values of a single table.

Learn more

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here