Hello fellow FME enthousiasts,

I have a case which i can't seem to find a solution for.

We have a process that adds a score to incoming records based on certifications added as hyperlinks in a table.

During several steps these certifications have to be manually checked by an employee. Finally when everything has been approved the records are written to a central database (this can only be done when all the records have been approved, so the whole dataset has to be kept together during the whole process). 

Right now i have the process setup to output all data to an Excel table (with a template to make it readable for the employee). Here the employee can select if a certification is approved or not. This Excel table is then put back into the next process untill all necessary checks have been done.

Each time a proces is run i would like to check at the end if all records are approved or not. Depending on the outcome two things can happen

• If ANY are not approved, ALL records needs to be output to the Excel table.
• If ALL records are approved, they can ALL be written to the database

I can check with a Tester if any records are not approved, but how do i build in that all records are either written to the Excel or Database depending on the outcome?

Any help would be much appreciated!

Cheers!