Hello people,
A few days ago I built a flow for collecting Scheduler's data for Tableau reporting. Everything went well, but I noticed that Scheduler (SQLite data) returns me wrong info.
As you can see from the image below, the flow highlighted in blue says it's finished and completed but with some errors as the red dot in the "Results" indicates that.
Now, when I look at the Scheduler's SQLite data (AS_Queue) and my Tableau report, I am seeing "Status" = Complete, but it is wrong info for me since the flow had some errors during the process.
Is there some solution for this - to pick up the values/data from the "Results" not the Status from "Queue".
I am collecting the data from these three SQLites:
1. AS_Applications
2. AS_Schedules
3. AS_Queue
So, the key point for my report is to see whether the flow is finished without or with the errors.
Completed flow/s with the errors will return status "Complete" and from my point of view is not valuable too much.
