@msg90 I tried a few things with something resembling your data and some dummy data. The dummy data does work your ‘data’ does not. Maybe you can provide some real data and also the desired outcome or you can try and adapt the example with three databases and a loop using either DuckDB or H2 for large datasets that you might want to process.
I think you will have some work to doe defining your exact task.