DBTable.MergeVariablesMatchingEx2

Extended matching variables merge with SQL matching option. Defaults to relational matching, fill unmatched with MD, auto determine text/numeric comparison, match by casename, all output variables, no selection conditions, keep multiples, no formatting, and spreadsheet creation.

Syntax Parameters Return Value 
FunctionDBTable.MergeVariablesMatchingEx2( _
    OptionalInputAsVariant= 0, _
    OptionalTypeAsSpreadsheetType1 = scMergeRelational, _
    OptionalUnmatched1 AsSpreadsheetType2 = scMergeFillWithMD, _
    OptionalUnmatched2 AsSpreadsheetType2 = scMergeFillWithMD, _
    OptionalMatchBy AsSpreadsheetType3 = scMergeAuto, _
    OptionalMatchLikeSQL AsBoolean= False, _
    OptionalMatchVariables1 AsVariant= 0, _
    OptionalMatchVariables2 AsVariant= 0, _
    OptionalOutputVariables1 AsVariant= 0, _
    OptionalOutputVariables2 AsVariant= 0, _
    OptionalselectionIncludeExpression1 AsString= "", _
    OptionalselectionIncludeList1 AsString= "", _
    OptionalselectionExcludeExpression1 AsString= "", _
    OptionalselectionExcludeList1 AsString= "", _
    OptionalselectionIncludeExpression2 AsString= "", _
    OptionalselectionIncludeList2 AsString= "", _
    OptionalselectionExcludeExpression2 AsString= "", _
    OptionalselectionExcludeList2 AsString= "", _
    OptionalDropMultiples1 AsBoolean= False, _
    OptionalDropMultiples2 AsBoolean= False, _
    OptionalCopyFormatting1 AsBoolean= False, _
    OptionalCopyFormatting2 AsBoolean= False, _
    OptionalVerifySorted AsBoolean= False, _
    OptionalPreserveOrder AsBoolean= False, _
    OptionalCurrentIsSorted AsBoolean= False, _
    OptionalMergeIsSorted AsBoolean= False, _
    OptionalCreateSpreadsheet AsBoolean= True) AsSpreadsheet
  • Input [in, optional]

    Type: Variant

    Default value: 0

  • Type [in, optional]

    Type: SpreadsheetType1

    Default value: scMergeRelational

  • Unmatched1 [in, optional]

    Type: SpreadsheetType2

    Default value: scMergeFillWithMD

  • Unmatched2 [in, optional]

    Type: SpreadsheetType2

    Default value: scMergeFillWithMD

  • MatchBy [in, optional]

    Type: SpreadsheetType3

    Default value: scMergeAuto

  • MatchLikeSQL [in, optional]

    Type: Boolean

    Default value: False

  • MatchVariables1 [in, optional]

    Type: Variant

    Default value: 0

  • MatchVariables2 [in, optional]

    Type: Variant

    Default value: 0

  • OutputVariables1 [in, optional]

    Type: Variant

    Default value: 0

  • OutputVariables2 [in, optional]

    Type: Variant

    Default value: 0

  • selectionIncludeExpression1 [in, optional]

    Type: String

    Default value: " "

  • selectionIncludeList1 [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeExpression1 [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeList1 [in, optional]

    Type: String

    Default value: " "

  • selectionIncludeExpression2 [in, optional]

    Type: String

    Default value: " "

  • selectionIncludeList2 [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeExpression2 [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeList2 [in, optional]

    Type: String

    Default value: " "

  • DropMultiples1 [in, optional]

    Type: Boolean

    Default value: False

  • DropMultiples2 [in, optional]

    Type: Boolean

    Default value: False

  • CopyFormatting1 [in, optional]

    Type: Boolean

    Default value: False

  • CopyFormatting2 [in, optional]

    Type: Boolean

    Default value: False

  • VerifySorted [in, optional]

    Type: Boolean

    Default value: False

  • PreserveOrder [in, optional]

    Type: Boolean

    Default value: False

  • CurrentIsSorted [in, optional]

    Type: Boolean

    Default value: False

  • MergeIsSorted [in, optional]

    Type: Boolean

    Default value: False

  • CreateSpreadsheet [in, optional]

    Type: Boolean

    Default value: True

Spreadsheet