Concatenate model data

Data Transformation Operations (DTOs) provide flexible and repeatable processes to concatenate model data. In the following examples you will see how you can concatenate model data using DTOs.

Data structured in models that you receive do not always provide data in a way that you can use. You need to concatenate data to create unique tags.

Make unique tag values for multiple objects

  1. Add a new DTO, and then name it Spool Number.

  2. In the Selector tab use the following criteria:

    Rule Type Tag
    Tag / OP Name Pipeline
    Operator

    contains
    Value RWS

  3. Use the and/or row toggle on the top left to select and.

  4. Click on the Add row icon on the bottom left to create a new row, and then use the following criteria:

    Rule Type Tag
    Tag / OP Name 00-CWA
    Operator not null

  5. In the Actions tab select Calculated for Action.

  6. Click the Add icon next to Action to add a function, and then use the following criteria:

    Function text()
    Tag Name 00-CWA

  7. Add additional rows, and then create a series of functions using dash as a constant as shown:

    Function text()
    Tag Name -
    Function text()
    Tag Name IN8_System - PowerPlant
    Function text()
    Tag Name -
    Function text()
    Tag Name IN8_LineNumber - PowerPlant
    Function text()
    Tag Name -
    Function text()
    Tag Name -01
    Function tag()
    Tag Name IN8_SpoolNumber

  8. Click on the Run selected button to execute the DTO and create the new tag according to your selection criteria.