calculated field failure
I have a calculated field that looks up an Item description from a custom table. If the Item doesn't exist in the table it should throw an error. My script throws an exception when the item doesn't exist in the table, but the Map itself doesn't fail. Is there a way to fail the map and with a specific error from the calculated field? Or does it need to be in a task before the map is run? When I run the map it logs the error (thrown exception) but it doesn't cause the map to fail.
Answers
Best Answer
If you want to be able to fail a record within an additional column you want to use the SQL Lookup option.
This allows you to try retrieve your value from the table, and then you can set it up to report failure if it doesn't find anything. Reporting failure in this case means failing that specific record the lookup fails within.
H
This allows you to try retrieve your value from the table, and then you can set it up to report failure if it doesn't find anything. Reporting failure in this case means failing that specific record the lookup fails within.
H