I'm tasked with developing an Alteryx workflow that iterates through a series of date ranges, such as the examples provided below. For each range, the workflow will execute a stored procedure. It's crucial to record whether each iteration is successful or fails.
Example date ranges:
1/1/2024 to 1/31/2024 (Assuming it fails)
2/1/2024 to 2/29/2024 (Assuming it succeeds)
Upon encountering a failed iteration, the workflow should log the error details and continue processing subsequent date ranges. Conversely, when an iteration succeeds, it should log this success before continuing to the next range. This process repeats for all provided date ranges.
Any help would be greatly appreciated...
Try the list runner/logging tools from crew macros that might help
http://www.chaosreignswithin.com/p/macros.html