Spreadsheet Ruleset Cell Formula Error
When trying to translate an Inbound Clarify Spreadsheet ruleset we receive an error.
In the source data (spreadsheet), one of the cells contains: #VALUE!
Step 4: Execute Transformation - Single Output
2019-03-22 07:34:33,106 [PERSISTENT] - Starting [email protected]8ec330
2019-03-22 07:34:33,107 [PERSISTENT] - Executing Version 2 Ruleset: "com.abc.fullmovelistxlsx.FullMoveListToAS400RS"
2019-03-22 07:34:33,107 [PERSISTENT] - Starting Transformation Engine
2019-03-22 07:34:55,845 [ERROR] - Cell AI8117 contains an Error.
2019-03-22 07:34:55,848 [PERSISTENT] - Ending Transformation Engine; Completed in 22741ms.
2019-03-22 07:34:55,848 [PERSISTENT] - Completed Task.
By substituting the "#VALUE!" string for a zero, the file was able to process successfully. This issue will need to be fixed on the file creation side.
By: Sean Hoppe on