MULTI VARA Objects

With MULTI VARA objects you can combine the values rendered by two different VARA objects. A MULTI VARA object definition is made up of the following pages:

General Page

Common to all object types, here you define basic object information and apply custom values to it
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. This topic describes the MULTI-specific settings on the Variables page.
Version Management Page

Common to all object types, here you find a list of all versions of the object
Documentation Page

Common to all object types, here you enter information that you consider important to understand the configuration and behavior of the object

To Define a MULTI VARA Object

In the Variable Settings section, specify how the VARA object is going to access the target system from which it retrieves the values.
- Type
  
  Read-only, always MULTI for this type of VARA objects.
- Variable 1
  
  VARA object from which the values are retrieved and combined with the values in Variable 2
  
  The values are taken from the reference columns in the VARA object that you select here. Each VARA object has it own reference column for this purpose. The reference columns are as follows:
  - STATIC : Key column
  - SQL, SQLI, MULTI: First column
  - FILELIST: Filelist column
  Important! Ensure that the value in the reference column has the same data type as the MULTI VARA object. Otherwise, an error occurs.
- Variable 2
  
  VARA object from which the values are retrieved and combined with the values in Variable 1
  
  If the VARA object that you select here does not contain the reference columns, no value from this VARA object is included in the result of the MULTI VARA object.
  
  The values that result from Variable 1 are used if the two VARA objects selected in Variable 1 and Variable 2contain entries with the same name.
- Operation
  - Union
    
    Retrieves all values of Variable 1 and Variable 2. If the variable entries are identical, the values of Variable 1 are used
  - Intersection
    
    Retrieves the values that are used both in Variable 1 and 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.
Define the Data Types and Formatting.
Define the Script Access.
If you are logged in to Client 0, an additional section is available. For more information, see Client 0 VARA Objects in Other Clients.
Click the Preview button to validate the VARA object. A preview of the result values is displayed.
Save your changes.