Hi! I'm working on a workflow to reconcile data (checks) between two databases. The workflow is straightforward with a join comparing check numbers and their corresponding statuses in each database. The challenge I'm facing is timing. One of the databases is a day behind; therefore, the comparison is not apples-to-apples. Within the database that is a day ahead, a field does not exist that would allow me to exclude data that was updated in the last 24 hours, thus aligning the two datasets. Without those data elements, my thought was to execute the workflow storing the data from the first query with the second query then not being initiated for "x" time after the initial run Within that time, the database that is behind would have been updated by a scheduled IT job making the comparison like-to-like prior to passing through the join.
I've explored Chained Workflows and also Crew Macros but still drawing a blank. Any suggestions would be greatly appreciated.
