In my scenario, I have an FME script that performs data validation. If the data is valid, it updates the database. However, if any records contain errors, I want to capture those records in an Excel file for users to review before uploading the data. In this error case, no data will be updated to database.
So, the logic I'm aiming for is as follows:
- Validate the data.
- After validating all data, capture all invalid records to an Excel file. Then, terminate the FME script without uploading the data to the database.
- If all data is valid, proceed to upload it to the database.
I've attempted to create a flow with a terminator, but the Excel writer doesn't have a connector. Connecting the terminator to the output port of the TestFilter after validation would terminate the writing of the error Excel file as well.
Can anyone provide suggestions to solve this issue?
