I am trying to build a workflow to show changes in reloaded datasets. The idea is to perceive change just in time to be able to react quickly to it, e.g. sudden high cost changes in projects. The loaded data are Excel files. You could call it an early warning system. It should also show certain columns, to the value that has changed.
Has anyone by chance already built something similar?
I have now applied the following workflow for my use case:
It doesn’t quite work the way I think it should. Namely, it reacts incorrectly to new content in the Excel files. If a new row is added to the original file, the data rows shift and thus there is an offset, so that the data no longer matches and everything from the new row is displayed FALSE.
I only want the new additions / changes to be displayed as FALSE.
Unfortunately I don’t know how to implement this.