Set

This is a transform tool which sets the value of a frame to a particular value.

The minimum configuration for a Set transform is the name of the field to transform and the value to set in that field:

"Set": { "Name": "empty", "Value": "" },

In the above the empty field in the working frame will be set to an empty string.

The value is evaluated as a template so any variable substitutions supported by the Symbol Table can be placed in the value text:

"Set": { "Name": "ContactName", "Value": "[#Context.working(usr_last_name)#],[#Context.working(usr_first_name)#]" },

The above sets the ContactName field to the value of the usr_last_name field in the working frame followed by a comma then the value of the usr_first_name field in the working frame. This effectively concatenates two fields into a third. This third field can subsequently be used in other transforms and phases of the transformation.

All transforms support boolean Expressions which dictate if they run or not:

"Set": { "Name": "terminator", "Condition": "islast", "Value": "2", "Default": "1" }

The above sets the terminator field to the default value of "1" unless the boolean condition is true. If so, then the value of the field will be "2". the isLast is a literal function supported by the B