Element Details: Match+Condition
 Back


Available in: Logi Info Source code name: MatchCondition

Defines the left and right side columns used to match DataLayer rows for a Join. Set LeftDataColumn to the name of a column from the DataLayer above the Join. Set RightDataColumn to the name of a column from the DataLayer below.

Add multiple MatchCondition elements to match on multiple columns.

Values must be exactly the same to be a match. Hint: Use add a CalculatedColumn if values need to be changed for better matching.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
DataType
Text
Number
Date
Specifies the type of data present.
ID
UserDefined
The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
LeftDataColumn
UserDefined
(Required) The name of a DataColumn used for matching rows with a Join. The DataLayer that is a parent to the Join is considered the "Left" side. The DataLayer below is the "Right".
RightDataColumn
UserDefined
(Required) The name of a DataColumn used for matching rows with a Join. The DataLayer that is a parent to the Join is considered the "Left" side. The DataLayer below is the "Right".



PARENT ELEMENTS

Click element to drill down for more information.

Join Sql Join


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top