Attribute Assistant using expression wild card

VanessaSimps — Thu, 18 Feb 2021 19:11:43 GMT

I have been tasked with populating two different fields from a single field. My plan was to use AA and either the Field, Field Trigger, or Expression function to populate the new fields.

Field where the values are added = FACILITYID

new Field 1 = FunctionalLocation

new Field 2 = EquipmentID

I plan to create two new entries into the Dynamic Value table

To populate the FunctionLocation field:

Table Name: swFacility
Field Name: FunctionLocation
Value Method: (unsure if this should be FIELD TRIGGER, FIELD, or EXPRESSION)
Value Info:
IIF([FACILITYID] LIKE 'E-MA%') &[FACILITYID]

To populate the EquipmentID field (this is a numeric field that is not consistent so I can't really wild card it) :

Table Name: swFacility
Field Name: EquipmentID
Value Method: (unsure if this should be FIELD TRIGGER, FIELD, or EXPRESSION)
Value Info:
IIF([FACILITYID] NOT LIKE 'E-MA%' OR IS NULL) &[FACILITYID]

I found a few other threads where they were using similar IFF statements, but none were using a wildcard in the expression.

Thanks in advance!

topic Attribute Assistant using expression wild card in Water Utilities Questions

Attribute Assistant using expression wild card