SmartMatch Feature

The SmartMatch feature in Astera adds to the reusability of file source objects used in flow documents (dataflows, workflows, and subflows). When the SmartMatch option is enabled, Astera checks for the specified alternate header values in a Synonym Dictionary file that is a part of the project.

How SmartMatch Option Works

Astera looks for the alternate header values using a step-by-step approach. First, it looks for an exact header match in the incoming source file and the object layout specified in the dataflow. Secondly, it checks for alternate headers in the field layout (as opposed to alternate headers in the synonym file).

Synonym Exact Match

If for any specific field, it is unable to find an exact header match, it then looks for the specified alternate header values in the synonym dictionary file.

Note: The Use SmartMatch with Synonym Dictionary option should be enabled for file sources to allow Astera to look for alternate header values in a Synonym Dictionary.

In a Synonym Dictionary file, it will look for exact variants first. For example, if the synonym file has an entry ShippingID=Shipping Number, Astera will read data from fields marked ShippingID and Shipping Number in the same way.

Synonym Token Match

You can also create tokens in a Synonym Dictionary file.

For example, if you define that ID = Number|Num|number|#

Astera will store the values defined as a token and use it to read data wherever an exact header match is not found. Tokens are useful to handle layout differences in multiple header fields at once.

For instance, for the token created for ID, shown above, Astera will handle unmapped data fields as shown in the table below:

Customer ID
Customer Number
Customer Num
Customer number
Customer #

Shipping ID

Shipping Number

Shipping Num

Shipping number

Shipping #

Order ID

Order Number

Order Num

Order number

Order #

Compact String Match

If there are still unmapped fields, Astera will remove whitespaces and punctuation characters and attempt to match the source to the target.

© Copyright 2023, Astera Software