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!
