Description

I have a script that includes a formula as a mapped field. When running the script the formula is not executed, nothing is being returned into the Excel cell column that is defined within the transform formula screen.

Applies To

Transaction/Studio scripts.

Cause

As per Winshuttle design and for the purpose of any script execution, you must map at least one field which means that one field must be uploaded during the script run. If your only upload field is the same as the transform formula then Winshuttle will recognize this as a fixed value and it will not work.

Solution

You need to also map another field within the script as an upload field.