FlowEngine Data Standardize & CleanInstall

Summary

Convert a specified field's value to a target data type (string, number, boolean, or integer) with options to save to a different field, set a default on failure, and track changes or debug information.

Inputs

• Source Field (required) — The name of the field whose value you want to convert.
• Target Type (required) — The data type to convert the value to, choosing from string, number, boolean, or integer.
• Output Field — Field to save the converted value into; if empty, overwrites the original source field.
• Default Value — Value to use if conversion fails; if empty, keeps the original value.
• Options — Additional settings including case insensitive field name matching, whether to continue on failure, debug mode to include detailed process data, skipping unchanged items from output, and tracking changes made.

Output shape

a list of items where each item's JSON is the input JSON with the specified field converted and saved accordingly

If 'Output Field' is empty, the original field is overwritten; otherwise, the converted value is saved to the specified output field. The operation can include optional _changes and _debug fields in the JSON objects when enabled. If 'Skip Unchanged' is set, items with no effective change are excluded from output. Errors in conversion can be handled by providing a default value or continuing processing other items.

Examples

Example 1: Convert a 'price' field formatted as a string with currency symbols to a number, saving the result in a new field 'price_num'.

Source Field: 'price'; Target Type: 'number'; Output Field: 'price_num'; Default Value: empty; Options as needed.

Example 2: Convert a 'subscribed' field containing 'yes'/'no' strings to boolean values, overwriting the original field.

Source Field: 'subscribed'; Target Type: 'boolean'; Output Field: empty (overwrites original); Default Value: 'false' (if conversion fails).