I need to run rather extensive workspace to update database tables from an XML file. The update files can generated every day and are avaible for two months to past. When processing the worskpace I download these update XML and write them them. So far no problem.

During the execution I need to check the continuity against a table in the database. So I would need to load up to 60 files read the header with date (1) and previous file information pass it to tester, process first file with all writes (2), write a row to database table with a header information about file processed (3) and take the next files to process from failed tester (4) and fetch them again to SQL executor.

I'm not sure about the loop part as it seems there can´t be writers inside and I also miss attributes passed from feature reader. Not sure how to correctly arrange it.

An idea is to pass it later to FME server and run every day, so no or just one file would be processed. But the workspace needs to be able to process also up to two months of day files.