Support site for Simplebim® users
In This Topic
    Enrichment Worksheet
    In This Topic

    With Enrichment you can efficiently merge data from external sources into the model by setting property values to objects that match a given criteria. You can add as many Enrichment Worksheets into the workbook as you like and they will be processed if the name of the Worksheet starts with 'Enrichment'. Each Enrichment Worksheet can contain as many Enrichment sections as you wish.

    Each Enrichment section must be formatted like this.

    The easiest way to get this right is to copy and paste the sample section on the Enrichment worksheet.

    Insert the name of the Object Class or Group on Column C on the row where Column B has the text 'Object or Group [+]' (Cell C4 in the picture above).

    Use the special value '[GROUP]' as the 'Object or Group [+}' to set the values of the properties of a group. In this option the match property is always the name of the group and the operator in Match (case insensitive).

    Define one Match property by giving a property name or key. This property is used for finding the objects for which the other properties are set. The match property must be a Text property. The Match operator can have the following values.

    Match Operators Description
    Equals Must be the same text
    Contains Must contain the text
    Starts With Must start with the text
    Ends With Must end with the text
    Like Using wildcards
    Match Using regular expression
    Not Equals Must not be the text
    Not Contains Must not contain the text
    Not Starts With Must not start with the text
    Not Ends With Must not end with the text
    Not Like Using wildcards
    Not Match Using regular expression

    The format for the Operator in a Match cell is ’Match=<Operator>’, for example ‘Match=Equals’. If the Operator is mixed case the match will be case sensitive, otherwise case insensitive.

    Examples Case Sensitive
    Match = equals No
    Match = EQUALS No
    Match=Equals Yes

    All whitespace (spaces) is trimmed from the Operator, for example ‘Starts With’ is the same as ‘StartsWith’.

    New in Simplebim 9.1 SR1

    You can use the special value [EMPTY] as the match value. Using this value means that you want to enrich all objects where the Match property has no value.

    Define as many Set properties (Operator = Set) as you wish by giving a property name or key. If needed simply add new properties on column F, G, H and so on. These are the properties for which the values are set. Set properties can be of any data type (text, number, measure…). Do not leave any empty columns in between.

    You can also define Info properties (Operator = Info) that are not processed but could help you better understand the data or save you the trouble of deleting columns you don’t want to include. Info columns can be used between Set columns.

    On the rows below the header (containing the Object Class and Properties) add as many rows as you wish. Each row must have a value for the Match Property and optionally values for the Set Properties. Do not put any value into the cell on column B, because column B is reserved for use by the system.

    If you set measure value, please pay attention to the Template Units.