Using Neo4j 4.1.0, I was wondering if it's possible to detect patterns where transactions are being split up and then merged together. The following example is a trail of payments between users, where user 1 is paying user 6 $500.
Here, User 1 is splitting the money up via two different routes and different amounts so they don't pay user 6 directly.
I understand it's easy to hard-code a query that matches this, but is it possible to write queries that detect this pattern in various forms (where user 1 is paying user 6 indirectly, using various transactions and other users)? What about if more than 2 branches were used?
Any guidance will be much appreciated.