This class describes an equality relation between two columns in different tables.
A relation like '[Tbl1].[Column1] = Upper([Tbl2].[Column1])' is defined using two expressions
'[Tbl1].[Column1]' and 'Upper([Tbl2].[Column1])'. These expressions are evaluated in the different
source tables, so if one of the tables are external then you can use the methods provided by that
external data source and if the table is not external then you can use the standard Spotfire expression
language functions. Additionally you can also provide left and right transform expressions which are evaluated
on top of the left/right expressions supporting all standard Spotfire expression language functions.
These expression refer to the result of the corresponding expression using the name ValueColumnName.
For example you need to perform "Upper" on Tbl2 but the external system doesn't support that method you can define
left and right expressions like '[Tbl1].[Column1]' and '[Tbl2].[Column1]' but add additional transform expressions like
'[Value]' and 'Upper([Value])'.
Inheritance Hierarchy
Spotfire.Dxp.DataColumnRelation
Namespace: Spotfire.Dxp.Data
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 25.11.10401.3615 (25.11.10401.3615)
Syntax
C#
[ImmutableAttribute] public sealed class ColumnRelation
The ColumnRelation type exposes the following members.
Constructors
Name | Description | |
---|---|---|
ColumnRelation(String, String) |
Initializes a new instance of the ColumnRelation class.
| |
ColumnRelation(String, String, String, String) |
Initializes a new instance of the ColumnRelation class.
|
Methods
Name | Description | |
---|---|---|
Equals(Object) | Determines whether the specified Object is equal to the current Object. (Overrides ObjectEquals(Object).) | |
Equals(ColumnRelation) |
Will evaluate if the descriptors are the same.
The descriptors are considered equal even if the order of the expressions (left/right) are reversed.
| |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) | |
GetHashCode | Serves as a hash function for a particular type. (Overrides ObjectGetHashCode.) | |
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
Properties
Name | Description | |
---|---|---|
LeftTableName |
Gets the name of the left table.
| |
RightTableName |
Gets the name of the right table.
| |
ValueColumnName |
Gets the name of the value column used for transforming the data.
|
Version Information
See Also