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: 30.0.11525.4184 (30.0.11525.4184)
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.
             | 
|  | GetHashCode | Serves as a hash function for a particular type. (Overrides ObjectGetHashCode.) | 
|  | GetType | Gets the Type of the current instance.(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