MULTI VARA Objects

MULTI VARA objects 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:

  • 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

  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. Click the Preview button to validate the VARA object. A preview of the result values is displayed.

  5. To export the content of the preview table to a CSV file, click Export Table. All rows and column are exported. Use this function if you need to further process the content of the CSV file (paste it to a different application for further processing and so on).

  6. To copy one or more rows in the Preview table, select the Copy button. The selected rows are copied to the clipboard and you can paste them to a third party tool (Google, Sheets, Excel, text editor, and so on).

    Note: This function is available only if https is used on the Automic Web Interface .

  7. Save your changes.

See also: