DBTable.MergeVariablesConcatenate

Concatenate variables merge. Defaults to fill unmatched with MD, all output variables, no selection conditions, no formatting, and spreadsheet creation.

Syntax Parameters Return Value 
Function DBTable.MergeVariablesConcatenate( _
    Optional Input As Variant = 0, _
    Optional Unmatched As SpreadsheetType2 = scMergeFillWithMD, _
    Optional OutputVariables1 As Variant = 0, _
    Optional OutputVariables2 As Variant = 0, _
    Optional selectionIncludeExpression1 As String = "", _
    Optional selectionIncludeList1 As String = "", _
    Optional selectionExcludeExpression1 As String = "", _
    Optional selectionExcludeList1 As String = "", _
    Optional selectionIncludeExpression2 As String = "", _
    Optional selectionIncludeList2 As String = "", _
    Optional selectionExcludeExpression2 As String = "", _
    Optional selectionExcludeList2 As String = "", _
    Optional CopyFormatting1 As Boolean = False, _
    Optional CopyFormatting2 As Boolean = False, _
    Optional CreateSpreadsheet As Boolean = True) As Spreadsheet
  • Input [in, optional]

    Type: Variant

    Default value: 0

  • Unmatched [in, optional]

    Type: SpreadsheetType2

    Default value: scMergeFillWithMD

  • 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: " "

  • CopyFormatting1 [in, optional]

    Type: Boolean

    Default value: False

  • CopyFormatting2 [in, optional]

    Type: Boolean

    Default value: False

  • CreateSpreadsheet [in, optional]

    Type: Boolean

    Default value: True

Spreadsheet