MULTI VARA Objects

Use MULTI VARA objects to combine the values rendered by two different VARA objects.

Defining MULTI VARA Objects

A MULTIVARA object definition is made up of the following pages:

• General Page

• Variables

  Here you define the object-specific settings. Some sections on this page are common to all VARA objects and are described for all of them in dedicated topics:

  • Variable Settings
  • Data Types and Formatting
  • Script Access
  • Client 0 VARA Objects in Other Clients
  • Preview
• Version Management Page
• Documentation Page

Variable Settings Section

• Type

  Read-only, always MULTI for this type of VARA objects.

• Variable 1 / Variable 2

  VARA objects that serve as source for the MULTI VARA object.

  Variable 1 determines the number of columns. The reference columns' values of both variables are combined depending on the operation that has been specified. The reference column depends on the variable source: Key column (in static variables), first value column (variable source: SQL, SQL-internally, Multi), or the Filelist column (variable source: Filelist). Columns that are not included in Variable 2 do not include a value for the corresponding entries.

  The values of Variable 1 are used if two Variable objects contain entries of the same name.

  Important! The data type of the source variable's reference column should match the Multi variable's data type. Otherwise, an error occurs or the values are not available.

• Operation

  • Union: Retrieves all values of the Variables 1 and 2. If the variable entries are identical, the values of Variable 1 are used.
  • Intersection: Retrieves the values that are used in Variable 1 and that are also in Variable 2. If the values are identical, the Result/Key column entries of Variable 1 are used.
  • Difference: Retrieves all values of Variable 1 that are not contained in Variable 2. The Result/Key column entries of the variables are compared to each other.

Preview Section.

To preview the variable, click Preview. A preview of the result values is displayed.

See also:

• VARA Objects
• Variables and VARA Objects