DecideJoinType()

Summary

Determines if the right fields of a join have duplicates for aggregation.

Syntax

type = DecideJoinType(string join_fld, array options)

Returns

The string "A" if duplicates are found, null otherwise.

Notes

• DecideJoinType() returns "A" when JoinViews() or JoinViewsMulti() function with the "A?" option would create an aggregate join, rather than a one-to-one join.

• Just as in JoinViews() or JoinViewsMulti(), the existence of duplicates is based on a partial reading, rather than examining the entire table.

Example

// See if there are many sales records per state
type = DecideJoinType("Sales.State", {"zero as missing", "True"})
if type = "A" then title = "Accumulated sales per state"
else title = "Sales per state"
// Now link the Sales table to the table of states
new_view = JoinViews("StateSales", "[U.S. States].Name", "Sales.State", {{type}})
// Show the resulting table with the appropriate title
CreateEditor(title, new_view + "|", , )

Error Codes

See Also