I really want to push the topic of flows to the maximum (and develop the low‑code/no‑code approach). I’m already quite comfortable with flows, but I want to take things to the next level. I know there’s an issue with promotes that should be fixed in the next LTS release. I’m not sure if what I’m seeing is related to that.
My goal is the following: I take a detailed source table, aggregate it to produce a summary, and archive the daily results. My flow works perfectly when I run it manually, but it fails when it’s scheduled.
Here’s what I’ve done: I start from a detail table, run a query to aggregate it, and save the result in a CAS library. In that same library, I previously created an archive table with the same structure. Then I add a data step to insert rows. Finally, I add another query to work around the promote issue.
I believe everything is set up correctly. But when it runs automatically, it seems to start from scratch every time, as if the table generated by the row‑insertion step was never promoted.
Can you help me?
