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:

To Define a MULTI VARA Object

  1. 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.

  2. Define the Data Types and Formatting.
  3. Define the Script Access.
  4. If you are logged in to Client 0, an additional section is available. For more information, see Client 0 VARA Objects in Other Clients.
  5. Click the Preview button to validate the VARA object. A preview of the result values is displayed.
  6. Save your changes.

See also: